'Step' or Matrix Calculations
 

Here it goes.

Sales %
0-$250,000 0
$250,001-$500,000 15
$500,001-$1,000,000 20
$1,000,001-$2,000,000 25
$2,000,001-$3,000000 30

So I cant figure out the formula that would give me my desired result as
illustrated as follows. If a person sells between 0 and $250k, then don't
apply a percentage, but if that person sells $750k: dont apply a percentage
on the first $250k in sales, 15% on the amount between $250,001 and $500,000
and finally 20% on all sales above $500,001.

Thanks.

'Step' or Matrix Calculations
 

This link explains how to do it:

http://www.mcgimpsey.com/excel/variablerate.html

Hope this helps.

Pete

On Dec 24, 12:04*am, RBG wrote:
Here it goes.

Sales * * * * * * * * * * * * * * * * *%
0-$250,000 * * * * * * * * * * * * * 0
$250,001-$500,000 * * * * * * * 15
$500,001-$1,000,000 * * * * * *20
$1,000,001-$2,000,000 * * * * 25
$2,000,001-$3,000000 * * * * *30

So I cant figure out the formula that would give me my desired result as
illustrated as follows. *If a person sells between 0 and $250k, then don't
apply a percentage, but if that person sells $750k: dont apply a percentage
on the first $250k in sales, 15% on the amount between $250,001 and $500,000
and finally 20% on all sales above $500,001.

Thanks.