result sheetClosed

Question

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

akinator1e · Answer

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

epsiman · Answer

Try youtube.com you can find all sort of tutorials!!!

a · Answer

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

Result sheet

3 responses

Similar discussions

Subscribe To Our Newsletter!