Excel Formula

formula to calculate sum
=SUM(D7:O7) or (D7+E7+F7......+O7)
-------------------------------------------------------------------
formula to calculate percentage
=(totalobtained marks)/(total full marks) * 100
-------------------------------------------------------------------
formula for division
=IF(AND(Q7>=80),"Dist",IF(AND(Q7>=60),"First",IF(AND(Q7>=45),"Sec",
IF(AND(Q7>=40),"Third","Fail"))))
-------------------------------------------------------------------
formula to calculate pass or fail
=IF(AND(C9>=32,D9>=32,E9>=32,F9>=24,G9>=8,I9>=24,J9>=8,L9>=24,M9>=8,
O9>=32,P9>=16,Q9>=16),"Pass","Fail")
-------------------------------------------------------------------
formula to calculate grade

=IF(D2/75*100>=90,"A+",IF(D2/75*100>=80,"A",IF(D2/75*100>=70,"B+",
IF(D2/75*100>=60,"B",IF(D2/75*100>=50,"C+",IF(D2/75*100>=40,"C",
IF(D2/75*100>=30,"D+",IF(D2/75*100>=20,"D",
IF(D2/75*100<20,"E","abs")))))))))
-------------------------------------------------------------------
Formula to calculate grade point
=IF(Y2="A+",4,(IF(Y2="A",3.6,IF(Y2="B+",3.2,(IF(Y2="B",2.8,
IF(Y2="C+",2.4,IF(Y2="C",2,IF(Y2="D+",1.6,IF(Y2="D",1.2,
(IF(Y2="E",0.8,0))))))))))))
-------------------------------------------------------------------
For to calculate ranks
=IF(R13="Fail","-",RANK(Q13,$Q$7:$Q$58))
-------------------------------------------------------------------
To show remarks
==IF(AND(Q14>=80),"good result",
IF(AND(Q14>=66),"SATISFACTORY! WORK HARDER.",
IF(AND(Q14>=50),"WORK HARDER; YOU CAN DO STILL HARDER.",
"MAKE EVERY eENDEAVOUR.")))
----------------------------------------------------------------------