Conditional IF Statements - cumulative calc.

[Guest]

Folks,
I am trying to write an IF statement that will do the following:

It calculates a commission amount based on 3 level of Sales:

If Sales is < = $1,500, calculate 0.0025*1500

If Sales is < = $3,000, calculate 0.0045*3000

If Sales is > $3,000, calculate 0.0050* cell reference...

Now, this may look easy enough..here's the trick that needs to happen

Say, sales is $5,500..the commission calculated should be cumulative i.e.
0.0025 * 1500, + .0045*3,000 + .0050*(remainder amount)

What would be a clean way of doing this? I will appreciate any help. Thanks.

Regards,
Shams.

 

[Biff]

Hi!

See this:

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

Biff