Back to All Formulas
LogicalLevel 2: Orange (Formulas & Operators)Difficulty: Beginner
How to Use IFS in Excel
Evaluates multiple logical conditions sequentially without complex nested IF statements.
Formula Syntax
=IFS(logical_test1, value_if_true1, logical_test2, value_if_true2, , TRUE, default_value)
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| logical_test1 | Required | The first condition that evaluates to TRUE or FALSE. |
| value_if_true1 | Required | The result returned if test1 is TRUE. |
| TRUE, default_value | Optional | Catch-all final condition to prevent #N/A errors. |
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Student | Score | Grade |
|---|---|---|
| Priya | 92 | A |
| Rohan | 74 | B |
| Arjun | 58 | C |
Applied Formula:Result: A
=IFS(B2>=90, "A", B2>=75, "B", B2>=60, "C", TRUE, "Fail")
How it works: Checks score against 90, 75, 60 in order and assigns the appropriate grade cleanly.
Common Errors & How to Fix Them
#N/A
Why it happens: None of the conditions evaluated to TRUE and no default TRUE fallback was provided.
Fix: Always add TRUE as the final test condition, e.g. =IFS(A1>10, 'High', TRUE, 'Low').
Ready to Master Excel?
Explore 7 LevelsMaster IFS in Level 2
Learn IFS alongside 500+ formulas, hands-on practice workbooks, and verifiable certificates.