Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
STEP MULTIPLY FUNCTION
I am trying to create a function for calculation of commissions. We have a
step up calculation we are using this year, ex revenue lower than 2mill will be 6.5% of rev, greater than 2mill-3mill will be 8% and greater than 3 mill will be 10.5% of revenue. I would like a function that will automatically calculate monthly for whatever revenue I give it. Can anyone help me with a function that will achieve this for numbers such as 2100000 and 3100000 where the difference after the threshold of 2000000 and 3000000 will multiply by the new percentages (for the 3100000 example i need 2000000*6.5%+1000000*8%+100000*10.5%). Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can anyone povide step by step instructions on how to do the follo | Excel Discussion (Misc queries) | |||
can't install CD from Excel 2003 step by step | New Users to Excel | |||
Need step by step for entering data into combobox | Excel Discussion (Misc queries) | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |