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”)