How to Use the IFS Function
Last updated: 2026-09-06
⚡ Quick Answer
The IFS function checks whether one or more conditions are met and returns a corresponding value.
=IFS(A2>90, "A", A2>80, "B", A2>70, "C", TRUE, "F")📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =IFS(A2>90, "A", A2>80, "B", A2>70, "C", TRUE, "F")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | 94 | Score > 90 | =IFS(A2>90, "A", ...) | Grade A |
| 2 | 2 | 83 | Score > 80 | — | Grade B |
| 3 | 3 | 65 | Fallback Default | TRUE, "F" | Grade F |
🧠 Deep Dive
The IFS function checks whether one or more conditions are met and returns a corresponding value.
Key Insights
- IFS evaluates conditions in order and stops at first TRUE.
- CHOOSE is index-based.
Common Mistakes
- Ordering IFS conditions loosely.
- Forgetting fallback condition.
Pro Tips
- Write decision tables on paper first.
- Test boundary values explicitly.
FAQ
What does this formula do in plain English?
The IFS function checks whether one or more conditions are met and returns a corresponding value.
Why is my formula not working?
Ordering IFS conditions loosely.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Forgetting fallback condition.
Related Guides
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)