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

Popular Posts