Skip to content
ExcelExcel 2019+

IFS function in Excel

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

=IFS(logical_test1, value_if_true1, [logical_test2…logical_test127], [value_if_true2…value_if_true127])

IFS syntax and parameters

Four arguments, two required.

  • logical_test1booleanRequired

    Condition that evaluates to TRUE or FALSE.

  • value_if_true1anyRequired

    Result to be returned if logical_test1 evaluates to TRUE. Can be empty.

  • logical_test2…logical_test127booleanRepeating

    Condition that evaluates to TRUE or FALSE.

  • value_if_true2…value_if_true127anyRepeating

    Result to be returned if logical_testN evaluates to TRUE. Each value_if_trueN corresponds with a condition logical_testN. Can be empty.

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 Google Sheets

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 Excel gets this done.