Thread: If Function
View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

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.