evaluates expression against list of values · from excel · excel: not yet compared · sheets: not yet compared

signature

SWITCH(expression, value1, result1, [default_or_value2…])

returns: any

argument	required
expression	required
value1	required
result1	required
default_or_value2…	optional

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• AND returns TRUE if all arguments are true
• EQ true when two values are equal
• FALSE returns the logical value FALSE
• GT true when the first number is greater
• GTE true when the first number is greater or equal
• IF returns one value if condition is true, another if false