View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default if then statements with calculations

cmac wrote...
I need to make a table that evaluates a number. *

If a number (x) is between (A) and (B), then I have to do a
calculation (C1) If a number is between (B) and (C), then I have to
do a calculation (C2) If a number is between C and D, then I have to
do a calculation (C3) If a number is greater than D, then I have to
do calculation (C4)


And if x <= A?

Brute force,

=IF(x<=A,"impossible",IF(x<=B,C1,IF(x<=C,C2,IF(x<= D,C3,C4))))

More elegant,

=CHOOSE(MATCH(x*0.999999999999999,{-1E300;A;B;C;D}),"impossible",
C1,C2,C3,C4)