EXCEL FORMULA

1.SUM FORMULA
=SUM(B2:B7)
2.RESULT
=IF(B9>=33,"pass","fail")
3.RESULT EVERY SUBJECT
=IF(AND(B2>=33,B3>=33,B4>=33,B5>=33,B6>=33,B7>=33),"pass","fail")
4.DIVISION FORMULA
=IF(B9>=60,"first",IF(B9>=40,"second"))
5.
=SUM(Total of No)+enter
6
=SUM(No+No)+enter
7.
=SUM(No,No)+enter
8.
Alt=+enter
9.
=IF(B3<C3,"Profit","Loss")+enter
10.
=IF(B3<C3,C3-B3,B3-C3)+enter
11.
=E4*100/B4