CASE
Returns specified values when condition is met
CASE(expression
, when
, return value
, else
)
Evaluates expression
and returns values depending on expression values.
Inputs
expression
Expression to be evaluated
when
Value(s) that could match expression values
return value
Value to return if when
matches expression
else
Value to return if when
does not match expression
Output
Outputs a series of values depending on expression
values
Example
Last updated
Was this helpful?