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
|