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

See

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

In article .com,
"Andy" wrote:

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