Sorry, the formula should be multiplied by C2.
=C2*CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.03 2)
Jason
-----Original Message-----
An alternative to multiple IF functions:
=CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.03 2)
HTH
Jason
Atlanta, GA
-----Original Message-----
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?
.
.
|