🧮 Day 52: IF Function (MS Excel) – Hinglish
IF Function (MS Excel) – Hinglish
📌 IF Function kya hota hai?
IF Function ek logical function hai jo condition check karta hai.
👉 Agar condition true ho → ek result
👉 Agar condition false ho → dusra result
🧠 IF Function ka Formula (Syntax)
=IF(condition, value_if_true, value_if_false)
👉 Simple words me:
=IF(shart, sahi result, galat result)
✅ Example 1: Pass / Fail Result
📊 Data:
| Name | Marks | Result |
|---|---|---|
| Rahul | 45 | |
| Priya | 75 |
👉 Condition:
Marks ≥ 50 → Pass
Marks < 50 → Fail
🧮 Formula (C2 cell):
=IF(B2>=50,"Pass","Fail")
👉 Result:
Rahul → Fail
Priya → Pass
✅ Example 2: Grade System
📊 Condition:
Marks ≥ 90 → Excellent
Marks < 90 → Normal
Formula:
=IF(B2>=90,"Excellent","Normal")
✅ Example 3: Discount Calculation
👉 Condition:
Amount ≥ 1000 → Discount = Yes
Otherwise → No
Formula:
=IF(B2>=1000,"Yes","No")
🧠 Important Points (Exam ke liye)
✅ IF function logical test karta hai
✅ Operators used:
(greater than)
< (less than)
= (greater than or equal)
<= (less than or equal)
= (equal to)
🧪 Practice Task (Important)
👉 Excel me ye data enter karo:
| Name | Marks | Result |
|---|---|---|
| Amit | 40 | |
| Neha | 60 | |
| Rohit | 90 |
Tasks:
Result column me Pass / Fail lagao
👉 Formula:
=IF(B2>=50,"Pass","Fail")
📝 Short Notes (Exam ke liye)
👉 IF Function = Condition-based result
👉 Syntax = IF(condition, true value, false value)