G Guest Feb 3, 2005 #1 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?
G Guest Feb 3, 2005 #2 Hi In D2 put: =IF(C2<=1000,C2*.01,IF(C2<10,C2*.02,IF(C2<1,C2*.032,""))) HTH Michael
J Jason Morin Feb 3, 2005 #3 An alternative to multiple IF functions: =CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032) HTH Jason Atlanta, GA
An alternative to multiple IF functions: =CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032) HTH Jason Atlanta, GA
J Jason Morin Feb 3, 2005 #4 Sorry, the formula should be multiplied by C2. =C2*CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032) Jason
Sorry, the formula should be multiplied by C2. =C2*CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032) Jason
H Harlan Grove Feb 3, 2005 #5 Jason Morin wrote... An alternative to multiple IF functions: =CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032) Click to expand... .... 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.
Jason Morin wrote... An alternative to multiple IF functions: =CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.032) Click to expand... .... 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.
