Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a Percent based on Tiered criteria
I have a table like this: used to determine commision
Percent $0 $200,000 1.00% $200,001 $500,000 2.50% $500,001 $800,000 4.00% $800,001 $99,999,999 6.00% Is there a function to calculate commision using this table? For example, if the total sales is $600,000, I need to sum 1% of the first $200,000 and 2.5% of the next $300,000 and 4% of the remaining $100,000. Thanks, A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a Percent based on Tiered criteria
This link shows how it can be done:
http://www.mcgimpsey.com/excel/variablerate.html Hope this helps. Pete On Jan 7, 5:12*pm, A Morrison <A wrote: I have a table like this: used to determine commision * * * * * * * * * * * * * * * Percent $0 * * *$200,000 * * * * * * * * * * * 1.00% $200,001 * * * *$500,000 * * * * * * * * * * * 2.50% $500,001 * * * *$800,000 * * * * * * * * * * * 4.00% $800,001 * * * *$99,999,999 * * * * * * 6.00% Is there a function to calculate commision using this table? For example, if the total sales is $600,000, I need to sum 1% of the first $200,000 and 2.5% of the next $300,000 and 4% of the remaining $100,000. Thanks, A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating the mode of a criteria-based range | Excel Discussion (Misc queries) | |||
Calculating Mode for multiple arrays based on criteria in another | Excel Worksheet Functions | |||
Calculating percent off a single cell | Excel Discussion (Misc queries) | |||
Calculating a tiered 401k Match | Excel Worksheet Functions | |||
Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions |