Excel IFS Function

IFS checks tests in order and returns the result for the first TRUE test.

Use it when a formula needs several branches, such as grading bands, priority labels, tiered statuses, or cleaner alternatives to deeply nested IF formulas.

Add test-result pairs Each condition has an output

Check from left to right Excel stops at the first TRUE test

Return that result Later pairs are ignored

IFS syntax & arguments

Syntax

=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

Required Optional

1

logical_test1
Required

The first test Excel evaluates as TRUE or FALSE.
2

value_if_true1
Required

The result to return when logical_test1 is TRUE.
3

logical_test2, value_if_true2
Optional Repeatable

Additional test-and-result pairs. Excel checks them in order and returns the result for the first TRUE test.

Example

=IFS(C2>=90, "A", C2>=80, "B", TRUE, "Review")

Return A for scores at least 90, B for scores at least 80, and Review for everything else.

IFS caveats

The first TRUE test wins

Put narrower conditions before broader ones. In a score formula, test C2>=90 before C2>=80.
There is no automatic fallback

If no test is TRUE, IFS returns #N/A. Add a final pair such as TRUE, "Review" when every input should return something.
Tests and results must stay paired

Every logical test needs a matching result. A missing result leaves the formula incomplete.
Complex tests still need logical helpers

Use AND or OR inside a logical test when one branch depends on multiple conditions.