Excel Formula | Students Result Sheet

Post a Comment

Excel Formula | Students Result Sheet 

 

SUBJECT

 

 

 

 

 

 

NAME

HINDI

ENGLISH

POLTICAL

HISTORY

GEOGRAPHY

MAX.MARK

TOTAL

PARCENT

DIVISON

PASS/FAIL

GREAD

TAMESH

70

80

99

80

66

500

395

79

DISTENCE

PASS

A+

DEEPAK

77

77

88

33

55

500

330

66

FIRST

PASS

A

DINESH

88

65

44

54

44

500

257

51.4

SECOND

PASS

B

KRISHNA

77

56

66

56

67

500

322

64.4

FIRST

PASS

A

ARVIND

66

78

32

65

67

500

308

61.6

FIRST

FAIL

A

PINTU

55

87

44

67

89

500

342

68.4

FIRST

PASS

A

LUCKEY

66

67

33

22

22

500

210

42

THIRD

FAIL

C

SUNIL

77

76

33

56

90

500

332

66.4

FIRST

PASS

A

SANDIP

67

54

44

44

80

500

289

57.8

SECOND

PASS

B

SIDDHARTH

76

34

55

22

70

500

257

51.4

SECOND

FAIL

B

MANISH

67

54

66

78

60

500

325

65

FIRST

PASS

A

MONU

87

45

77

98

50

500

357

71.4

FIRST

PASS

A

NISHU

67

56

88

78

40

500

329

65.8

FIRST

PASS

A

SHERYA

67

67

99

67

49

500

349

69.8

FIRST

PASS

A

MANISHA

44

79

44

44

65

500

276

55.2

SECOND

PASS

B

RANJIT

32

87

88

67

57

500

331

66.2

FIRST

FAIL

A

PARDIP

68

66

77

76

69

500

356

71.2

FIRST

PASS

A

SUMAN

98

77

66

56

78

500

375

75

DISTENCE

PASS

A+

SUMIT

79

88

55

56

48

500

326

65.2

FIRST

PASS

A

TOTAL KA FORMULA  :- =SUM(B3+C3+D3+E3+F3)

PARCENT KA FORMULA :-  =SUM(H3/5)  ISKA CELL ADDRESS TOTAL KA HOTA HAI.

DIVISON KA FORMULA  :-                  =IF(I3>=75,"DISTENCE",IF(I3>=60,"FIRST",IF(I3>45,"SECOND",IF(I3>=33,"THIRD",IF(I3<=33 "FAIL")))))  ISKA CELL ADDRESS PARCENT KA HOTA HAI.

PASS/FAIL KA FORMULA  :-  =IF(B3<33,"FAIL",IF(C3<33,"FAIL",IF(D3<33,"FAIL",IF(E3<33,"FAIL",IF(F3<33,"FAIL","PASS")))))ISKA CELL ADDRESS PURE SUBJECT KA HOTA HAI.

GREAD KA FORMULA :-  =IF(I3>=75,"A+",IF(I3>=60,"A",IF(I3>=45,"B",IF(I3>=33,"C"))))   ISKA CELL ADDRESS PARSENT KA HOTA HAI. 

 SUPPLY KA FORMULA  :-   
=IF(B3<33,0,1)ENTER KARNE PAR 1 AAYEGA    
=IF(C3<33,0,1)ENTER KARNE PAR 1 AAYEGA
=IF(D3<33,0,1) ENTER KARNE PAR 1 AAYEGA      
=IF(E3<33,0,1) ENTER KARNE PAR 1 AAYEGA      
=IF(F3<33,0,1) ENTER KARNE PAR 1 AAYEGA 

SUB KO SUM KARNA HAI   FHIR NEXT CELL ME YE FORMULA ENTER KARNA HAI    =IF(G3>5,"PASS",IF(G3>4,"SUPPLY",IF(G3>3,"SUPPLY",IF(G3>2,"FAIL"))))ENTER



Post a Comment

Post a Comment