SWITCH Function
The SWITCH function is one of the logical functions. It is used to evaluate one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
Syntax
SWITCH(expression, value1, result1, [default_or_value2, result2], ...)
The SWITCH function has the following arguments:
Argument |
Description |
expression |
The value that will be compared against value1 ...value126. |
value1 ...value126 |
The value that will be compared against expression. |
result1 ...result126 |
The result to be returned if the value1 ...value126 matches to the expression. |
default |
The result to be returned if there are no matches. If the default argument is not specified and there are no matches, the function returns the #N/A error. |
Notes
You can enter up to 254 arguments i.e. up to 126 pairs of values and results.
How to apply the SWITCH function.
Examples
The figure below displays the result returned by the SWITCH function.
Return to previous page