Hi
In D2 put:
=IF(C2<=1000,C2*.01,IF(C2<10,C2*.02,IF(C2<1,C2*.03 2,"")))

HTH
Michael

"meekone" wrote:

If C2<1 then D2=c2*.032 If C2<10 then D2=C2*.02 If C2<=1000 then D2=C2*.01
How would I do this?