I have a pivot table and I want to put in a formula to calculate a commission% based off of the margin%. I'm having a hard time coming up with a simple formula.
Below is the structure. Basically, if a salesperson sells an item with X margin% then he/she gets paid x commission%.
40%-49% = range of 2.6% to 4.9%
50% - 59% = range of 5% to 9.9%
60% and above = 10%
Below 40% = 2.5%
Any help would be greatly appreciated!!
Below is the structure. Basically, if a salesperson sells an item with X margin% then he/she gets paid x commission%.
40%-49% = range of 2.6% to 4.9%
50% - 59% = range of 5% to 9.9%
60% and above = 10%
Below 40% = 2.5%
Any help would be greatly appreciated!!
