MAX Excel ka ek important function hai jo diye gaye numbers ya cells ke group me se sabse badi value (Highest Value) find karta hai.
Simple words mein:
MAX = Sabse badi value find karna
| Item | Details |
|---|---|
| Function Name | MAX |
| Purpose | Sabse badi numerical value find karna |
| Syntax | =MAX(number1, number2, ...) |
| Range Syntax | =MAX(A2:A10) |
| Result | Highest numerical value |
| Example | =MAX(60,70,80,90,100) |
| Result | 100 |
| Subject | Marks |
|---|---|
| English | 60 |
| Hindi | 70 |
| Computer | 80 |
| Maths | 90 |
| Science | 100 |
Agar marks B2:B6 mein hain, to formula hoga:
=MAX(B2:B6)
Result: 100
Marks → Values ko check karta hai → Highest Value identify karta hai → Result deta hai
Example:
60, 70, 80, 90, 100 → MAX → 100
MAX function ka use:
Leave a Reply