For Marksheet Tips

For Total (K7)

=SUM(c7:j7) 

For Result (L7)

=IF(AND(c7>=32,d7>=32,e7>=32,f7>=32,g7>=32,h7>=32,i7>=32,j7>=32),"Fail","Pass")
=IF(OR(c7<32,d7<32,e7<32,f7<32,g7<32,h7<32,i7<32j7<32)  For Percentage (M7) =M7/800*100  For Division (N7) =IF(AND(N7>=80),"Distinction",IF(AND(N7>=60),"Fisrt",IF(AND(N7>=40),"Second",IF(AND(N7>=32),"Third","Fail"))) 

For Remarks (O7)

=IF(N7="Distinction","Excellent",if(N7="First","First","Very Good",if(n7="Second","Good",IF(n7="Third","Satifactory","Try Again"))) 

For Rank (P7)

=RANK(M7,M7:M15) 

Or Other's

=RANK(M7,$M$7:$M$15) 