| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto compute | Excel Worksheet Functions | |||
| formulas will not compute | Excel Worksheet Functions | |||
| compute a percentage | New Users to Excel | |||
| Formulas that don't compute | Excel Worksheet Functions | |||
| mutiple regression help | Excel Discussion (Misc queries) | |||
Hybrid Mode
