🧮 Day 51: MIN & MAX Functions (MS Excel) – Hinglish
MIN & MAX Functions (MS Excel) – Hinglish
📌 MIN & MAX kya hote hain?
Excel me:
MIN() = Sabse chhota number nikalta hai
MAX() = Sabse bada number nikalta hai
🔽 1) MIN Function
✅ Use:
Data me se smallest value find karna.
📌 Syntax:
=MIN(range)
📊 Example:
| Marks |
|---|
| 45 |
| 78 |
| 60 |
| 90 |
👉 Formula:
=MIN(B2:B5)
👉 Result = 45 (sabse chhota number)
🔼 2) MAX Function
✅ Use:
Data me se largest value find karna.
📌 Syntax:
=MAX(range)
📊 Example:
| Marks |
|---|
| 45 |
| 78 |
| 60 |
| 90 |
👉 Formula:
=MAX(B2:B5)
👉 Result = 90 (sabse bada number)
🧠 Important Points (Exam ke liye)
✅ Function hamesha = se start hota hai
✅ Range format = B2:B10
✅ MIN = Lowest value
✅ MAX = Highest value
🧪 Practice Task (Important)
👉 Excel me ye data enter karo:
| Name | Marks |
|---|---|
| Rahul | 80 |
| Priya | 95 |
| Amit | 70 |
| Neha | 60 |
Tasks:
Lowest Marks = MIN
Highest Marks = MAX
👉 Formulas:
=MIN(B2:B5)
=MAX(B2:B5)
📝 Short Notes (Exam ke liye)
👉 MIN Function = Minimum value
👉 MAX Function = Maximum value