Excel IFS: Multiple Conditions Without Nesting
By Szabó Gergő · Updated
IFS evaluates condition and value pairs in order and returns the first match. It is easier to read than nested IF when you have several mutually exclusive outcomes.
Syntax and arguments
=IFS(logical_test1, value1, [logical_test2, value2], ...)- logical_test1
- The first TRUE/FALSE test Excel should check.
- value1
- The result when the first test is TRUE.
- additional pairs
- Optional extra tests and results, evaluated top to bottom.
IFS examples
Score is B2.
=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",B2>=60,"D",TRUE,"F")TRUE as the last test is a default so every score returns a letter.
Due date is C2.
=IFS(C2="", "Missing", C2<TODAY(), "Overdue", TRUE, "Open")Blank due dates are handled before the overdue comparison.
Annual revenue is E2.
=IFS(E2>=100000,"Enterprise",E2>=25000,"Growth",E2>0,"Starter",TRUE,"None")Larger thresholds must appear first or they will never match.
Common mistakes
No default pair
End with TRUE, "fallback" so unmatched inputs do not return #N/A.
Tests in the wrong order
Put the most specific or largest threshold first.
Using IFS for overlapping independent flags
Use separate IF or SWITCH columns when more than one label can apply.
IFS FAQ
Is IFS better than nested IF?
For a single result from several exclusive tests, yes. Nested IF is still common in older workbooks.
Why does IFS return #N/A?
No test was TRUE. Add a final TRUE pair as a default.
Can IFS return a formula?
The value can be a number, text, or another formula such as a lookup.