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