HOW TO PREPARE MARKSHEET IN EXCEL
MARK SHEET | |||||||||||||
S.NO |
NAME |
TAMIL |
ENGLISH |
MATHS |
SCIENCE |
SOCIAL SCIENCE |
TOTAL |
MIN |
MAX |
AVERAGE |
PASS/FAIL |
GRADE |
RANK |
1 |
RANI |
75 |
89 |
85 |
96 |
78 |
423 |
75 |
96 |
84.6 |
PASS |
A |
1 |
2 |
KAMALA |
96 |
85 |
48 |
68 |
59 |
356 |
48 |
96 |
71.2 |
PASS |
B |
4 |
3 |
RAMYA |
58 |
48 |
78 |
96 |
63 |
343 |
48 |
96 |
68.6 |
PASS |
B |
5 |
4 |
PRIYA |
96 |
58 |
48 |
92 |
87 |
381 |
48 |
96 |
76.2 |
PASS |
B |
2 |
5 |
RADHA |
73 |
59 |
85 |
69 |
81 |
367 |
59 |
85 |
73.4 |
PASS |
B |
3 |
FORMULA:
TOTAL : =SUM(C5:G5)
MAX : =MAX(C5:G5)
MIN : =MIN(C5:G5)
AVERAGE : =AVERAGE(C5:G5)
PASS/FAIL : =IF(AND(C5>=35,D5>=35,E5>=35,F5>=35,G5>=35),”PASS”,”FAIL”)
GRADE : =IF(AND(K5>=81,K5<=100,L5=”PASS”),”A”,
IF(AND(K5>=51,K5<=80,L5=”PASS”),”B”,
IF(AND(K5>=35,K5<=50,L5=”PASS”),”C”,”NO
GRADE”)))
RANK : =IF(L5=”PASS”,RANK(H5,$H$5:$H$9),”NO RANK”)
$ -
ABSOULTE REFERENCE
Comments
Post a Comment