Result sheet
Closed
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
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
Related:
- Result sheet
- Ms excel result sheet - Guide
- Windows network commands cheat sheet - Guide
- Sheet right to left in google sheet - Guide
- Little alchemy cheat sheet - Guide
- How to open excel sheet in notepad++ - Guide
3 responses
akinator1e
Posts
5
Registration date
Wednesday February 4, 2009
Status
Member
Last seen
May 3, 2009
Mar 22, 2009 at 08:24 AM
Mar 22, 2009 at 08:24 AM
hi,
try this link, you will get a book on excel formulas.
try to find the formula that you need in it:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPP1,M1
try this link, you will get a book on excel formulas.
try to find the formula that you need in it:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPP1,M1
epsiman
Posts
306
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
162
Mar 22, 2009 at 11:35 AM
Mar 22, 2009 at 11:35 AM
Try youtube.com you can find all sort of tutorials!!!