checks multiple conditions, returns first match · from excel · excel: not yet compared · sheets: not yet compared

signature

IFS(logical_test1, value_if_true1, [logical_test2…], [value_if_true2…])

returns: any

argument	required
logical_test1	required
value_if_true1	required
logical_test2…	optional
value_if_true2…	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