| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commission Percentage
Hi, I have a figure say 44600(this number can change at any time). On the
first $20000 of that figure 2% is to be deducted, on the next 20000.00 4 % and on the balance 5%. is there anyway that this can be worked out?. I tried with a "IF" formula was not getting the result i had hoped. HELLLLPPP!! -- Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Commission Percentage
See
http://www.mcgimpsey.com/excel/variablerate.html In article , workjunkie wrote: Hi, I have a figure say 44600(this number can change at any time). On the first $20000 of that figure 2% is to be deducted, on the next 20000.00 4 % and on the balance 5%. is there anyway that this can be worked out?. I tried with a "IF" formula was not getting the result i had hoped. HELLLLPPP!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| commission calculation | Excel Worksheet Functions | |||
| NEED HELP! Commission calculation | Excel Discussion (Misc queries) | |||
| Commission Spreadsheet Help | Excel Discussion (Misc queries) | |||
| Percentage Commission on a sliding scale. | Excel Discussion (Misc queries) | |||
| commission spreadsheet | Excel Worksheet Functions | |||
Linear Mode
