**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.")))

----------------------------------------------------------------------

Good job.

ReplyDeletegood

ReplyDelete