SWITCH function is used to evaluate a single expression against multiple possible values or conditions, returning a result based on the first match it finds. When no match is found, SWITCH can return an optional default value.
Excel Switch Function
Syntax
=SWITCH(expression,val1/result1,[val2/result2],...,[default])
- expression – The value or expression to match against.
- val1/result1 – The first value and result pair.
- val2/result2 – [optional] The second value and result pair.
- default – [optional] The default value to use when no match is found.
The first argument in SWITCH is called “expression” and can be a hard-coded constant, a cell reference, or a formula that returns a specific value to match against. Matching values and corresponding results are entered in pairs. SWITCH can handle up to 126 pairs of values and results. The last argument, default, is an optional value to return when there is no match.