Conditional IF Statements - cumulative calc.

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.

Hi!

See this:

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

Biff

"Shams" <[email protected]> wrote in message
news:[email protected]...
> 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.