Nested IF Statements in Excel

Nested IF Statements in Excel

Nesting IF statements lets you test multiple conditions inside a single formula — perfect for advanced logic like grading levels or salary brackets.

🧠 Basic Formula:

=IF(A2>75,"Distinction",IF(A2>=50,"Pass","Fail"))

📘 Breakdown:

• First, check if score >75 → “Distinction”
• Else, check if score ≥50 → “Pass”
• Else → “Fail”

📌 Real Use Cases:

• School grade sheets
• Leave approvals
• Performance ratings

🎁 Download Nested IF Practice File

ScriptDataInsights Gumroad

🔔 Follow @ScriptDataInsights on all platforms for more smart logic tricks.