Excel SWITCH function

Function              SWITCH

Description        Excel SWITCH function returns multiple choices of results with multiple types of values .

Syntax  SWITCH(expression, val1/result1, [val2/result2], …, [default])

expression  The value or expression to match against, cell reference.

val1/result1  The first value and result.

val2/result2  [optional] The second value and result.

default  [optional] The default value to use when no match is found.

Example:

Suppose I am putting a value from 1 to 5 in a cell A1 and in B1 it will return a value against A1.

=SWITCH(A1,1,“Very Poor”,2,“Poor”,3,“Average”,4,“Good”,5,“Awesome”,“Wrong input, try again”)