Calculate Sliding Scale Calculation

[Andy]

I need to be able to calculate a commission as follows:

Total Amount=$500
Total Commission (0-$100, 5%)+($101-399, 10%)+(>$400, 15%)

This would calculate a different percentage for each of the ranges
above and then add them together. I hope I'm making myself clear
because I'm confused just writing this.

It seems like there should be a very easy way to do this in Excel.

Any assistance would be most appreciated.

Thanks,
Andy

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/variablerate.html