# Salary Formula ( Calculation of Basic and commission)

Waleed
✭✭✭✭

Hi ,

I need formula for (Net Salary) col as follow :

To Count the sum in Col (Basic Salary)

Plus sum of 15% for amounts equal/less than 600 and sum of 25% for amounts more than 600) of the number in Col (Total Income)

We Pay our Employee (ex. sales man) salary with compensation of basic salary PLUS markup commission as follow:

- Basic salary (Ex . fixed amount 100, 150 etc)
- Plus, 15% for all incomes equal to 600 and less
- Plus, 25% for all amounts more than 600

Examples as in attachment: The employee Amanda salary is (365) as her sales amount is 1300 which is counted as follow:

Basic (100) , Plus 15% for amount 600 (which is 90) and plus 25% for amounts above 600 (which is 175)

Can we have formula for this 🙄

Tags:

## Answers

## Help Article Resources

#### Categories

- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives

Want to practice working with formulas directly in Smartsheet?

Check out the

Check out the

**Formula Handbook template!**