Skip to content
Google Sheets

IFS function in Google Sheets

Evaluates multiple conditions and returns a value that corresponds to the first true condition.

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

IFS syntax and parameters

Four arguments, two required.

  • condition1anyRequired

    The first condition to be evaluated. This can be a boolean, a number, an array, or a reference to any of those.

  • value1anyRequired

    The returned value if condition1 is TRUE.

  • condition2anyOptional
  • value2anyRepeating

IFS examples

Formulas you'll actually reuse.

  1. Grade banding without nested IFs — the TRUE arm is the catch-all:

    =IFS(B2 >= 90, "A", B2 >= 80, "B", B2 >= 70, "C", TRUE, "Needs review")

    Result"B"

  2. Status from a date column, empty cells called out explicitly:

    =IFS(C2 = "", "Missing date", C2 > TODAY(), "Scheduled", TRUE, "Done")

    Result"Scheduled"

IFS in Excel

Same name — your formula ports as-is.

Try IFS in the playground

Edit the example — nothing to install.

Preloaded with the IFS formula from Example 1 — change anything and watch it respond.

Loading the editor…

IFS errors

What they mean — and the fixes.

  • #N/A

    Every condition evaluated to FALSE — add a final `TRUE, <fallback>` pair as the default arm.

Related functions

More ways Google Sheets gets this done.