The IFS function in Excel

Q: How do I add an "else" to IFS?

Make the last test TRUE. Since TRUE is always true, its result is returned whenever nothing earlier matched.

IFS checks a list of conditions in order and returns the result for the first one that's true. It replaces long nested IF formulas when you're sorting values into bands: performance ratings, shipping tiers, or ticket SLA status. Each condition sits next to its result, so the formula reads almost like a rule book.

Syntax

=IFS(test1, value1, [test2, value2], ...)

test1	The first condition to check, like `B2>=1.2`.
value1	The result to return if `test1` is TRUE.
test2, value2, ...	Optional. More condition and result pairs, checked in order. Add `TRUE` as the last test to act as "everything else".

Try it yourself

This is a live spreadsheet. Type the formula and press Enter.

In D2, use IFS to label the ticket's SLA status from the hours open in C2: more than 48 hours is "Breached", more than 24 is "At risk", and anything else is "On time".

	A	B	C	D
1	Ticket	Priority	Hours open	SLA status
2	T-501	High	30
3	T-502	Low	6
4	T-503	Medium	52
5	T-504	High	12
6	T-505	Low	75
7
8
9

Tip: Check the larger threshold first, and finish with TRUE so every ticket gets a label.

Examples

=IFS(B2>=1.2,"Exceeds",B2>=1,"Met",B2>=0.8,"Close",TRUE,"Below")→ "Exceeds"

Rates Jamal's attainment against four bands. Tests run from the highest threshold down, and TRUE catches anything left.

=IFS(C3="Gold",0.12,C3="Silver",0.09,C3="Bronze",0.06)→ 0.09

Maps Rosa's tier to a commission rate. Each text value gets its own result.

=IFS(B5>=1,"Bonus",TRUE,"No bonus")→ "No bonus"

Even a simple two-way rule works. Here Ivy is below 100%, so the catch-all result is returned.

Example data

1	Rep	Attainment	Tier
2	Jamal	126%	Gold
3	Rosa	103%	Silver
4	Ken	84%	Bronze
5	Ivy	61%	Silver

Common mistakes

Conditions in the wrong order
IFS stops at the first TRUE. If you test B2>=0.8 before B2>=1.2, everyone above 80% gets the lower label. Start with the strictest condition.
No catch-all, so #N/A
If none of the tests are true, IFS returns #N/A. End the formula with TRUE,"Other" so every value gets a result.
#NAME? in older Excel
IFS isn't available in Excel 2016 or earlier. Use nested IF there, or a lookup table with approximate matching.
A test without a result
Tests and results must come in pairs. An odd number of arguments means Excel can't tell which result belongs to which test.

FAQ

What's the difference between IF and IFS?+

IF handles one condition with two outcomes. IFS handles many conditions in a flat list, so you don't need to nest one IF inside another.

How do I add an "else" to IFS?+

Make the last test TRUE. Since TRUE is always true, its result is returned whenever nothing earlier matched.

Which Excel versions support IFS?+

Excel 2019, Excel 2021, Microsoft 365 and Excel for the web. Excel 2016 and earlier show #NAME?.

Lesson

Master IFS step by step: Nested IF and IFS

Handle more than two outcomes, like letter grades or commission bands, with nested IFs or the cleaner IFS.

Related functions

IF IFERROR