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

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