Excel Function

SWITCH

Matches expression to values and returns mapped result.

SWITCH(expression, value1, result1, [default])

Arguments

expression

Required

Enter an expression such as comparison or calculation.

value1

Required

Enter a text value (wrap with quotes when needed).

result1

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

show outputs based on conditions. Use SWITCH to Matches expression to values and returns mapped result. use C2 for expression, use 80 for value1, use "A" for result1. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SWITCH(C2, 80, "A")

Practice This Function

Practice in Sequential Mode Back to Function List