Excel mein students ke grades assign karne ke liye hum IF function ka use karte hain. IF function aapko ek condition check karne ki suvidha deta hai aur agar woh condition true hoti hai toh ek value return karta hai, aur agar false hoti hai toh doosri value return karta hai. Hum is function ka use student ke marks ke basis par unhe grades assign karne ke liye karenge.
Scenario:
Aapke paas ek list hai jisme students ke names aur unke marks diye gaye hain. Aapko un marks ke basis par grades assign karne hain. Grades ko assign karne ke liye hum following criteria use karenge:
- 90 marks aur usse zyada: Grade A+
- 80 se 89 marks: Grade A
- 70 se 79 marks: Grade B
- 60 se 69 marks: Grade C
- 50 se 59 marks: Grade D
- 50 se kam: Grade F (Fail)
Step-by-Step Process:
Step 1: Data Entry
Pehle aap apne data ko enter karenge. Excel mein data kuch is tarah se hoga:
| Student Name | Marks |
|---|---|
| Ali | 95 |
| Sara | 88 |
| Usman | 72 |
| Fatima | 56 |
| Asim | 48 |
Step 2: Grade Assignment Using IF Function
Aap IF function ko use karke grades assign karenge. Formula ka structure kuch is tarah hoga:
=IF(Marks >= 90, "A+", IF(Marks >= 80, "A", IF(Marks >= 70, "B", IF(Marks >= 60, "C", IF(Marks >= 50, "D", "F")))))
- Marks >= 90: Agar marks 90 ya usse zyada hain, toh "A+" grade assign hoga.
- Marks >= 80: Agar marks 80 ya usse zyada hain lekin 90 se kam hain, toh "A" grade assign hoga.
- Marks >= 70: Agar marks 70 ya usse zyada hain lekin 80 se kam hain, toh "B" grade assign hoga.
- Marks >= 60: Agar marks 60 ya usse zyada hain lekin 70 se kam hain, toh "C" grade assign hoga.
- Marks >= 50: Agar marks 50 ya usse zyada hain lekin 60 se kam hain, toh "D" grade assign hoga.
- Else (F): Agar marks 50 se kam hain, toh "F" grade assign hoga.
Step 3: Apply Formula
Aap Grade column mein formula ko apply karenge. Maan lijiye student marks column B mein diye gaye hain, aur aap grade assign karna chahte hain column C mein.
Toh C2 cell mein aap yeh formula likhenge:
=IF(B2 >= 90, "A+", IF(B2 >= 80, "A", IF(B2 >= 70, "B", IF(B2 >= 60, "C", IF(B2 >= 50, "D", "F")))))
Phir aap yeh formula C2 cell se neeche ke cells mein drag karenge.
Step 4: Results
Formula ko apply karne ke baad, Excel automatically student ke marks ke basis par grades assign karega. Aapke data ka output kuch is tarah hoga:
| Student Name | Marks | Grade |
|---|---|---|
| Ali | 95 | A+ |
| Sara | 88 | A |
| Usman | 72 | B |
| Fatima | 56 | D |
| Asim | 48 | F |
Explanation:
- Ali ke marks 95 hain, jo 90 se zyada hain, isliye grade "A+" assign kiya gaya.
- Sara ke marks 88 hain, jo 80 se 89 ke beech hain, isliye grade "A" assign kiya gaya.
- Usman ke marks 72 hain, jo 70 se 79 ke beech hain, isliye grade "B" assign kiya gaya.
- Fatima ke marks 56 hain, jo 50 se 59 ke beech hain, isliye grade "D" assign kiya gaya.
- Asim ke marks 48 hain, jo 50 se kam hain, isliye grade "F" assign kiya gaya.
Step 5: Alternate Approach (Using Nested IFs)
Aap same result achieve karne ke liye CHOOSE aur MATCH function ka bhi use kar sakte hain. Lekin agar aapko sirf grades assign karna hai toh IF function sabse simple aur efficient method hai.
Alternate Formula with CHOOSE and MATCH:
Aap marks ko ek rank de kar grade assign kar sakte hain:
=CHOOSE(MATCH(B2, {0, 50, 60, 70, 80, 90}, 1), "F", "D", "C", "B", "A", "A+")
Is formula mein:
- MATCH(B2, {0, 50, 60, 70, 80, 90}, 1): Yeh formula marks ke range ko identify karta hai aur uske corresponding grade ko return karta hai.
- CHOOSE: Yeh function us rank ke according grade return karta hai jo MATCH ne identify kiya hai.
Conclusion:
Excel mein IF function ka use marks ke basis par students ko grades assign karne ke liye karna bohot asaan hai. Aap nested IF statements ke through complex conditions ko handle kar sakte hain aur automatically grade assign kar sakte hain. Ye method aapko student performance tracking aur reporting mein madad karta hai.