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