Result sheet

Closed
jaan - Mar 22, 2009 at 02:44 AM
 a - Oct 24, 2010 at 01:33 PM
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
akinator1e Posts 5 Registration date Wednesday February 4, 2009 Status Member Last seen May 3, 2009
Mar 22, 2009 at 08:24 AM
0
epsiman Posts 307 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 163
Mar 22, 2009 at 11:35 AM
Try youtube.com you can find all sort of tutorials!!!
0