The IFS function is used to test multiple conditions without writing nested IF formulas.
It makes formulas cleaner, shorter, and easier to understand.
Instead of writing many IF statements inside each other, IFS checks conditions one by one.
Structure of IFS Function
=IFS(logical_test1, value_if_true1,
logical_test2, value_if_true2,
logical_test3, value_if_true3, ...)
Explanation:
- Excel checks the first condition.
- If TRUE → returns the result.
- If FALSE → checks the next condition.
- Continues until a TRUE condition is found.
Basic Example (Grading System)
If marks are in cell A1:
=IFS(A1>=80,"A",
A1>=60,"B",
A1>=40,"C",
A1<40,"Fail")
Meaning:
- 80 or more → A
- 60–79 → B
- 40–59 → C
- Below 40 → Fail
Example (Sales Commission)
If sales are in A1:
=IFS(A1>5000,"High Bonus",
A1>3000,"Medium Bonus",
A1>1000,"Low Bonus",
A1<=1000,"No Bonus")
Excel returns the first TRUE result.
Difference Between IF and IFS
| IF | IFS |
|---|---|
| Used for one condition | Used for multiple conditions |
| Can become complex with nesting | Cleaner and easier to read |
| Requires nested IF for multiple tests | No nesting needed |
Important Notes
- IFS does not require a “value_if_false” at the end.
- It returns the first TRUE condition.
- Arrange conditions carefully (highest to lowest is recommended).
When to Use IFS
- Grading systems
- Commission calculation
- Performance evaluation
- Category classification
- Multiple decision-making logic
Why IFS is Important
It helps you:
- Simplify complex formulas
- Improve readability
- Reduce formula errors
- Work efficiently with multiple conditions
The IFS function is a modern and powerful alternative to nested IF statements in Excel.