MS.EXCEL grade formula

[faizan341]

Jab Hum Excel Main Marksheet Banatey Hain O Us Main Grade Ka Kya Formula Hota Hai Yani Kis Tarah Hum Grade Nikal Saktey Hain

[smsaeed]

yes bhi ap grade nikalsaktay ho aram say
grade say phelay ap ko % nikalni hogi us ka farmula ap ko ata hay agar han to acchi bat hay nahi to likhay
hasal karda marks ko zarab karday 100 say or phir dived toral marks
(hasil karda marks*100/toral marks
us kay bad if ki command lagani hay

[NadeemGul]

Dear iss k liye aap ko pata hona chahiye k aap kitne marks pe kon sa grade de rahay hain. aam tour par to 90 se above ko A+ diya jaata hain aur issi tarah 80% se 90% tak A aur........
Excel main aap IF function se ye kaam kar sakte hain. See this
=IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))

[Rashid Jan]

ese dekh kar aap thankx

[Titanic]

thanks

[NadeemGul]

good work Rashid, keep it going dear.

[faizan341]

thank u alot sir

[feroztime]

Friends good explanationsssssssss

[Rashid Jan]

asif bhai aap ek hi naam se kiun save kar rahe the file ab aap dobara file banao to acha he itna time dhoundh ne mein lag jai ga thankx

[sam alien]

thanx

[IT.BOY]