mutiple if statements that then compute a value

[cmac]

I am trying to put together a sales commission formula that pays out at each
different levels depending on the sales value. But, I can't seem to get it
to total correctly. Any suggestions?

fees payout percentage
0-15000 15%
15001-30000 14%
30001-50000 13%
50001-75000 12%
75001 and greater 11%

Thanks for any help

 

[Pete_UK]

Check out this link:

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

which explains how to do it.

Hope this helps.

Pete