MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel formula

Posted by afaz miah on October 17, 2001 6:10 AM

i have a table of results on an excel spreadsheet. it has a list of 20 students and the their percentage grades in 8 separate subjects. it is all set out on a large table.
my job is to make a formula where all the students who have passed (got over 35% in all the subjects) get the word 'pass'. where all the students who failed only one (one under 35%) get a 'refer' message, and where all those students who failed two (two under 35%) get a 'fail' message.

Posted by afaz maih on October 17, 2001 6:12 AM

the whole thing should change simultaniously when one of the grades is adjusted on the table.

Posted by Aladin Akyurek on October 17, 2001 6:35 AM


The following should suffice:


B2:I2 houses the 8 grades of the first student. Copy down this formula for all students.