IFS
LogicalExcel 2019Check several conditions in order and return the first match.
Syntax
IFS(test1, value1, [test2, value2], …)
How it works
Replaces long nested IFs. No built-in "else" — add TRUE as the last test for a default.
Examples
=IFS(A2>=90,"A", A2>=75,"B", A2>=40,"C", TRUE,"F")
→ grade band
Good to know
- Returns #N/A if nothing matches and you didn't add a TRUE catch-all.
Related functions
More Logical functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.