Result sheet

Closed
Report
-
 a -
Hello,
i am having a problem to make a result for student. for example if a student getting 25 marks in a paper he or she is passing in that subject but pass marks are 41 i am applying this formula in grade column

=IF(J7>=80,"A1",IF(J7>=70,"A",IF(J7>=60,"B",IF(J7>=50,"C",IF(J7>=40,"D","FAIL")))))

If any student getting 80% in each subject exept one like 30% he or she is also got pass. i need your help
thanks

3 replies

Try this

=IF(J7>=80,"A1",IF(J7>=70,"A",IF(J7>=60,"B",IF(J7>=50,"C",IF(J7>=40,"D","FAIL")))))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
5
Registration date
Wednesday February 4, 2009
Status
Member
Last seen
May 3, 2009

Posts
307
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
163
Try youtube.com you can find all sort of tutorials!!!