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?

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?

An alternative to multiple IF functions:

=CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032)

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?
.

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?
.

.

Jason Morin wrote...
An alternative to multiple IF functions:

=CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.03 2)
....

You're not handling C21000, in which case your formula would return
#VALUE!. Lookup formulas like

=LOOKUP(C2,{-1E300,1,10,999.999999999999},{0.01,0.02,0.32,
"Unsupported: 1000"})

would scale much more easily as the number of transition points
increases.