Hey guys.
I'm having a lot of trouble with a formula to calculate commissions for my sales team.
This is how it works, we have five sales representatives in the team:
Sales Rep1
Sales Rep2
Sales Rep3
Sales Rep4
Sales Rep5
Ok. So each one of them has a minimum sales goal monthly. IF they...
from 1 to 1000000 = 6%
1000001 to 1500000 = 7%
1500001 to 2000000 = 8%
2000001 to 2500000 = 9%
2500001 to 3000000 = 10%
3000001 to 3500000 = 11%
3500001 to 4000000 = 12%
4000001 to 1000000000000000000000000000 = 12%
i need a formula to calculate the commision shown above in excel
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.