IFS pitfall 1: Conditions are evaluated top-to-bottom: order matters?

Conditions are evaluated top-to-bottom: order matters. The first match wins.

IFS pitfall 2: There's no built-in else clause?

There's no built-in else clause. Add a final `TRUE, default_value` pair to handle the fallthrough.

Returns `#N/A` if no condition matches. Wrap in `IFERROR` for safety.

Logiceasy

Evaluates multiple conditions and returns a value for the first TRUE.

Syntax

=IFS(condition1, value1, [condition2, value2, ...])

Example

=IFS(A1>90,"A", A1>80,"B", A1>70,"C")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and IFS isn't one of them yet.

Conditions are evaluated top-to-bottom: order matters. The first match wins.
There's no built-in else clause. Add a final TRUE, default_value pair to handle the fallthrough.
Returns #N/A if no condition matches. Wrap in IFERROR for safety.

Related formulas

Used by