Logical
Modern
IFS
Tests multiple conditions in order and returns the value for the first one that is TRUE.
Available in Microsoft 365 · Excel 2024 · Excel 2021 · Excel 2019 · Excel for the web. Not in Excel 2016 or earlier.
Syntax
IFS(logical_test1, value_if_true1, ...)What it returns
The value paired with the first condition that evaluates to TRUE.
Arguments
| Argument | Required | Description |
|---|---|---|
logical_test1 |
Yes | The first condition to test. |
value_if_true1 |
Yes | Value returned if logical_test1 is TRUE. |
… |
No | Add condition/value pairs as needed (up to 127 pairs). |
Example
| A | |
|---|---|
| 1 | Score |
| 2 | 85 |
Result
B
Checked top-down: 85 is not ≥ 90, but it is ≥ 80, so IFS stops and returns B.
=IFS(A2>=90,"A", A2>=80,"B", A2>=70,"C", TRUE,"F")Important to know
Conditions are evaluated in order — put the most restrictive first.
Returns #N/A if no condition is TRUE; add a final TRUE catch-all.
Not available in Excel 2016 or earlier.