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

expression – The expression or 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 (Optional) – 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

The relevant result is returned when the expression matches the value; otherwise, a default result is provided if there is 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