M
meekone
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?
How would I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michael
Hi
In D2 put:
=IF(C2<=1000,C2*.01,IF(C2<10,C2*.02,IF(C2<1,C2*.032,"")))
HTH
Michael
In D2 put:
=IF(C2<=1000,C2*.01,IF(C2<10,C2*.02,IF(C2<1,C2*.032,"")))
HTH
Michael
J
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
=CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032)
HTH
Jason
Atlanta, GA
J
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
=C2*CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032)
Jason
H
Harlan Grove
Jason Morin wrote...
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.
....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.