View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cmac cmac is offline
external usenet poster
 
Posts: 16
Default 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