Excel IFS Function (Many Ordered Tests) – Examples & Practice
Practice the Excel IFS function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Grade A2: return "A" if at least 90, "B" if at least 80, otherwise "C".
Formula Syntax
=IFS(logical_test1, value_if_true1, ...)
- logical_test1: First condition evaluated.
- value_if_true1: Result when the first test is TRUE.
- ...: Additional test/value pairs; add TRUE as the last test for a default.
What it does
IFS checks conditions in order and returns the value for the first TRUE condition. It replaces many nested IF formulas with a flatter structure.
Excel IFS Function Examples
Grade bands
=IFS(A2>=90, "A", A2>=80, "B", TRUE, "C")
Returns the first matching grade tier.
logical-checks.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Score | Attendance % | Approved |
| 2 | 92 | 96 | Yes |
| 3 | 78 | 88 | No |
| 4 | 85 | 91 | Yes |
| 5 | 66 | 84 | No |
| 6 | 90 | 93 | Yes |
| 7 | Output |
Input Formula
Need Help?
Tips
- Always include a final TRUE default when teaching beginners.
- Keep thresholds in a visible table for audits.
- Consider XLOOKUP to a tier table for complex policies.
IFS Function Use Cases
- Commission tiers
- SLA buckets
- Survey score bands
- Cleaner logic than nested IF
- Teaching ordered decision rules
Common mistakes - IFS function not working
- Forgetting the final TRUE catch-all
- Overlapping thresholds in the wrong order
- Using IFS when a lookup table is clearer
- Hard-coding tiers without a reference table
- Mixing inclusive/exclusive boundaries inconsistently
FAQ
IFS vs nested IF?
IFS lists tests and values in pairs, avoiding deep nesting for many tiers.
What is the default else case?
Include a final TRUE pair as a catch-all to avoid #N/A when no tests match.
Does IFS short-circuit?
Excel returns the first TRUE match in order; later tests are not used once a match is found.
IFS vs SWITCH?
SWITCH matches exact values; IFS evaluates arbitrary logical tests in order.
Can I mix text and numbers?
Yes, each test is its own logical expression.
Comparison
| Function | Style |
|---|---|
| IFS | Ordered tests |
| IF | Single binary test |
| SWITCH | Exact match mapping |
Example
=IFS(A2>=90, "A", TRUE, "B")
Advanced examples
IFS + LET
Modern Excel can combine LET with IFS to name intermediate values for readability in complex models.