MS EXCEL Mark sheet Formula

Excel  Mark sheet  Formula



Formula

Ms Excel Total Formula :

=Sub1+Sub2+Sub3+Sub4+Sub5

EX-  =B4+C4+D4+E4+F4 

Ms Excel Percentage(%) Formula :

=Total/Subjects
 Ex- 455/5

Ms Excel Grade Formula :


=IF(H4>=70,"A",IF(H4>=60,"B",IF(H4>=50,"c",IF(H4>=40,"D",IF(H4<=34,"Fail")))))

Ms Excel Result (Pass/Fail) Formula :

=IF(AND(B4>=35,C4>=35,D4>=35,E4>=35,F4>=35),"PASS","FAIL")

Download Excel File with Examples.