1. IF Condition Explained in 30 Seconds
🚦
Real-Life Analogy: The Traffic Signal
In real life, your brain evaluates IF conditions constantly:
1. Question (Test):
Is the traffic signal GREEN?
2. If TRUE (Yes):
Drive ahead 🚗💨
3. If FALSE (No):
Stop the car 🛑
Formula Anatomy: The 3 Parts of IF()
=IF( logical_test , value_if_true , value_if_false )1. LOGICAL TEST
The Question
A condition that evaluates to either TRUE or FALSE.
Score >= 402. VALUE IF TRUE
The WIN Output
What Excel returns if the logical test is TRUE.
"PASS 🎉"3. VALUE IF FALSE
The FALLBACK Output
What Excel returns if the logical test is FALSE.
"FAIL ❌"🎮 Live Interactive IF Logic Engine & Simulator
Play with input values and watch how the logic branch evaluates step-by-step in real-time!
Quick Presets:
⚙️ Controls & Parameters
75 Marks
⚡ Live Execution Flow
INPUT
Student Score = 75
DECISION TEST
Is 75 >= 40?
TRUE PATH
Condition Met!
"PASS 🎉"
FALSE PATH
Condition Failed!
"FAIL ❌"
FINAL RESULT RETURNED TO USER:PASS 🎉
=IF(A2 >= 40, "PASS 🎉", "FAIL ❌")2. Advanced IF Patterns (Nested IF & AND/OR)
NESTED IF
Multi-Level Grading (IF inside IF)
When you have more than 2 outcomes (e.g. Grades A, B, C, F), chain IF statements together.
85 / 100
Evaluated Grade:B (Good)
=IF(Score>=75, "B", ...)IF + AND / OR
Combining Multiple Rules
Enforce strict rules (ALL must pass with AND) or flexible rules (ANY can pass with OR).
=IF(AND(Sales>=10k, Rating>=4), "Bonus", "No")APPROVED (Bonus)
=IF(OR(Sales>=10k, Rating>=4), "Perk", "No")QUALIFIES (Perk)
🧪 Knowledge Check — IF Function Quiz
Question 1 of 5Score: 0