If Function

[Guest]

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?

 

[Guest]

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

HTH
Michael

 

[Jason Morin]

An alternative to multiple IF functions:

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

HTH
Jason
Atlanta, GA

 

[Jason Morin]

Sorry, the formula should be multiplied by C2.

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

Jason

 

[Harlan Grove]

Jason Morin wrote...

An alternative to multiple IF functions:

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

....

You're not handling C2>1000, 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.