Thanks for your elaborate reply. I used your suggestion but set up my
formula slightly different. It works. So, thank you very much for pointing
me at the right direction...

"B. R.Ramachandran" wrote:

> Hi Shams,
> I think I misunderstood your posting a liitle bit in my previous reponse.
> I thought that the commission is 0.0025 for upto 1500, 0.0045 for any amount
> in excess of 1500 (and less than 3000), and 0.005 for about 3000.
> For example, if the total sales amount is 3500, the commission is
> 0.0025*1500+0.0045*the next 1500+0.0050*500.
> However, I now see from your example, that if the sales amount is 5500, the
> commission is 0.0025*1500+0.0045*3000 (and not the next 1500) +0.0050* the
> remainder (I assume that you mean the amount in excess of 3000). If it is so
> use the following formula:
>
> =IF(A1>3000,17.25+(A1-3000)*0.005,IF(A1>1500,3.75+(A1-1500)*0.0045,A1*0.0025))
>
> Sorry about the confusion.
> 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.
> >