Take the 2-minute tour ×  In short, if one wanted to make an IF
switch  a) if A < 0.5 ... B = 10. b) if A >= 0.5 ... B = 15. c)
if A > 1.0 ... B = 20.  How would one go about that?
share|improve this question This is a simple basic excel
question, but i think you may not looking for straight forward
answer that is in terms of you using nested if. Is that right?
–  Siva Charan Feb 3 '12 at 12:30 @SivaCharan - Yeah, I'm
generally looking for an alternative to nested IF. Cause when
you have a bit more complicated switch case, or a more then
three choices, it gets very "ugly". –  ldigas Feb 3 '12 at 16:17
add comment  4 Answers  up vote 2 down vote accepted  This will
work as a SWITCH function:-   But this is internally doing
Nested IF.  Best Way to use 3 way switch is as follows:-
share|improve this answer add comment  You can nest "if"
expressions like this:
=IF(A1<0.5,10,IF(AND(A1>=0.5,A1<=1),15,IF(A1>1,20,"Something
else")))  (I added A1<=1 otherwise because A>1.0 implies A also
>= 0.5)  share|improve this