The IFS function, added in Excel 2019, is a cleaner way to handle multiple conditions than nesting a pile of IF statements. If you've ever written an IF formula with four closing parentheses at the end, IFS is for you.
The problem IFS solves
With the regular IF function, handling several outcomes means nesting — putting an IF inside the false slot of another IF:
=IF(A1>=90, "A", IF(A1>=80, "B", IF(A1>=70, "C", IF(A1>=60, "D", "F"))))
This works, but it's hard to read, easy to break, and the trailing parentheses are a nightmare to balance. IFS flattens it out.
The IFS syntax
=IFS(condition1, result1, condition2, result2, ...)
IFS checks each condition in order and returns the result for the first one that's true. The same grading example becomes:
=IFS(A1>=90, "A", A1>=80, "B", A1>=70, "C", A1>=60, "D", TRUE, "F")
Much cleaner — each condition/result pair sits side by side, and there's no nesting.
The order matters
IFS returns the first true condition, so sequence is critical. In the grading example, conditions go from highest to lowest. If you reversed them and put A1>=60 first, a score of 95 would match that condition immediately and return "D" — wrong. Always order conditions so the first match is the correct one, usually most-specific or highest-threshold first.
The catch-all: TRUE
Notice the TRUE, "F" at the end. Since TRUE is always true, it acts as a final "otherwise" — catching anything that didn't match earlier conditions. Without it, a value matching none of your conditions returns a #N/A error. Always include a TRUE catch-all at the end unless you specifically want #N/A for unmatched values.
A practical example
Categorize order sizes:
=IFS(B2>=1000, "Large", B2>=500, "Medium", B2>=100, "Small", TRUE, "Tiny")
Readable at a glance, and easy to add or adjust tiers.
IFS vs nested IF vs IF with AND/OR
- Use IFS when you have multiple distinct conditions leading to different results (like tiers or categories). It's the cleanest option.
- Use a single IF for simple two-outcome logic (
=IF(A1>=100, "Pass", "Fail")). - Use IF with AND/OR when a single result depends on multiple conditions being true together.
The version caveat
IFS requires Excel 2019, 2021, or Microsoft 365. In older versions it shows as #NAME?, so for workbooks shared with people on Excel 2016 or earlier, you'll need to fall back to nested IF. If everyone's on a modern version, IFS is almost always the better choice for multi-condition logic.
The takeaway
IFS replaces messy nested IF statements with a clean list of condition/result pairs, returning the first match. Order your conditions carefully (first true wins), always add a TRUE catch-all at the end to avoid #N/A, and enjoy never balancing five closing parentheses again — as long as you're on Excel 2019 or later.