SWITCH
Syntax
SWITCH(expression,val1,res1,val2,res2,...,val_n,res_n,default)Arguments
Return value
Example
SWITCH([AGE],30,"Young",55,"Old","Other")Excel equivalent
Last updated
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.
SWITCH(expression,val1,res1,val2,res2,...,val_n,res_n,default)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.
The relevant result is returned when the expression matches the value; otherwise, a default result is provided if there is no match.
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.
Last updated