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.