need formula for stair stepping commissions w/ diff %per step
 

I need a formula so all I have to do is enter the commission once
Example:
Commission amount $18,000.00
the first $1.00-$6000 is x by 15% = amount
$6,001 to $14,000x by 20% = amount
$14,000 to $20,000 x 25% = amount

Commission total
Can anyone help me?????

need formula for stair stepping commissions w/ diff %per step
 

If I understand correctly, then here's the short answer:
For a commissionable value in A1

This formula calculates the commission:
=SUM((A1/1000{0,6,14})*(A1/1000-{0,6,14})*1000*({15,5,10}/100))

In your example: 18,000 results in commission of 3,700

For the explanation (and much more), see this great website:
http://www.mcgimpsey.com/excel/variablerate.html

Does that help?
(Post back if you have more questions)
***********
Regards,
Ron

XL2002, WinXP


"Linda" wrote:

I need a formula so all I have to do is enter the commission once
Example:
Commission amount $18,000.00
the first $1.00-$6000 is x by 15% = amount
$6,001 to $14,000x by 20% = amount
$14,000 to $20,000 x 25% = amount

Commission total
Can anyone help me?????