All functions / Logical
SWITCH
Compares a value against a list and returns the matching result.
Syntax
=SWITCH(expression, value, result, [default_or_value1, [default_or_value2], …])
Arguments
expression: The value to compare.value: A value to match.result: Result for that match.default_or_value(optional): More value/result pairs, then an optional default.
Example
=SWITCH(A2, 1, "Mon", 2, "Tue", "Other") → Day name