Check multiple conditions in order and return the value for the first one that is true.
Syntax
IFS(test1, value1, [test2, value2], …)Arguments
test1required
The first condition to evaluate.
value1required
The value to return if test1 is TRUE.
test2…optional
Additional condition/value pairs.
IFS replaces deeply nested IF statements. It evaluates condition/value pairs from left to right and returns the value for the first TRUE condition. Add a final TRUE test as a catch-all default. Available in Microsoft 365 and Excel 2019+.
=IFS(B2>=90,"A", B2>=80,"B", B2>=60,"C", TRUE,"F")→BGrades a score across bands, with TRUE as the fallback.
List conditions high to low
Order tests so the first TRUE one wins — IFS stops at the first match.
Pair each test with a value
Alternate condition, value, condition, value.
Add a TRUE default
End with TRUE, "default" so nothing falls through to #N/A.
No condition was TRUE. Add a final TRUE test as a catch-all default value.