mutiple if statements that then compute a value
 

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

mutiple if statements that then compute a value
 

Check out this link:

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

which explains how to do it.

Hope this helps.

Pete

"cmac" wrote in message
...
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