What it does
IFS checks multiple conditions in order and returns the result for the first true condition.
Syntax or pattern
=IFS(test1, value1, test2, value2, ...)✅
5 practical examples
1
Grade scores
Convert numeric scores into grades.
=IFS(B2>=90,"A",B2>=80,"B",B2>=70,"C",TRUE,"Needs work")TRUE at the end acts as a final fallback.
2
Priority labels
Assign priority by days remaining.
=IFS(D2<0,"Overdue",D2<=3,"Urgent",D2<=7,"Soon",TRUE,"Later")Order conditions from most specific to broadest.
3
Sales tier
Classify sales performance into tiers.
=IFS(C2>=50000,"Gold",C2>=25000,"Silver",C2>=10000,"Bronze",TRUE,"Starter")Great for business classifications.
4
Inventory status
Label stock levels.
=IFS(B2=0,"Out",B2<10,"Low",B2<50,"OK",TRUE,"High")This makes inventory reports easier to read.
5
Age group
Create an age-band column.
=IFS(A2<18,"Under 18",A2<65,"Adult",TRUE,"Senior")IFS is easier to scan than deeply nested IF formulas.
Common mistakes to avoid
- Forgetting a final fallback condition.
- Putting broad conditions before specific ones.
- Using IFS when a simple IF would be clearer.
Related Excel examples
FAQ
What happens if no IFS condition is true?
Excel returns an error unless you include a fallback like TRUE.