🔀 Multi-Condition (IFS)

Goal: Assign a Grade based on the Score.
IFS checks conditions in order (1, 2, 3...) and stops at the first match.

Ready...

💻 Formula Structure

=IFS(test1, val1, [test2, val2], ...)
  • 1. Test 1: First check (e.g., Score > 89).
  • 2. Value 1: Result if Test 1 is True ("A").
  • 3. ... : Repeat for other conditions.
-- Grading Logic
=IFS(
  B2>89, "A",
  B2>79, "B",
  B2>69, "C",
  TRUE, "F" )
Final Grade:
-

⚠️ Common Pitfalls

🚫 Order Matters!
IFS stops at the first TRUE. If you check ">50" before ">90", a score of 95 will get the ">50" result.
✅ Fix: Start with the hardest condition first.
🚫 The "Catch-All"
IFS returns #N/A if none of the conditions are met.
✅ Fix: Use TRUE as your final condition to catch everything else (like "Else").