SWITCH

Evaluates an expression against a list of values and returns one of multiple possible result expressions. The first matching value is returned. If there is no match, an optional default value is returned. This function can be used to avoid having multiple nested IF statements.

Syntax

switch( expression, val1, res1, val2, res2, ... val_n, res_n, default )

Arguments

exp – The statement to be evaluated

val1, val2, … val_n – The list of values to be compared against the expression

res1, res2, … res_n – The result to be returned in case of a match

default – The default value to be returned if the expression does not match with any of the values in the argument list. This is an optional argument.

Return value

Relevant Result when the expression matches with the value, default in case there was no match.

Example

SWITCH([AGE], 30, "Young", 55, "Old", "Other")

Will return "Young" if the age is 30, "Old" if the age is 55, and "Other" for all other ages.

Excel equivalent

SWITCH