Salary Formula ( Calculation of Basic and commission)

Options
✭✭✭✭

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:

1. Basic salary (Ex . fixed amount 100, 150 etc)
2. Plus, 15% for all incomes equal to 600 and less
3. 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:

• ✭✭✭✭✭✭
Options

Hi @Waleed

Try this one...

=[Basic Salary]@row + (IF([Total Income]@row <= 600, [Total Income]@row * 0.15, 90 + (([Total Income]@row - 600) * 0.25)))

Ryan Sides

Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

Come Say Hello!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!