Hi Shams,

Try the following formula. It is configured assuming that the sales info is
contained in A1; change it appropriately.

=IF(A13000,10.5+(A1-3000)*0.005,IF(A11500,3.75+(A1-1500)*0.0045,A1*0.0025))

Regards,
B. R. Ramachandran


"Shams" wrote:

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.