how to calculate grade for 30 marks
Answers
Answered by
1
firstly calculate the marks in percent
Answered by
1
considering A1>25,A2>20,B1>15 ,B2>11,C>5 Rest D.
Formulae for Calc:(Cell Reference taking C1)
=if(C1>25,"A1",if(C1>20,"A2",if(C1>15,"B1",if(C1>15,"C","D"))))
Similar questions