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
Afaz,
The following should suffice:
=IF(COUNT(B2:I2)=8,IF(COUNTIF(B2:I2,"<35%")>1,"fail",IF(COUNTIF(B2:I2,"<35%")=1,"refer","Pass")),"")
B2:I2 houses the 8 grades of the first student. Copy down this formula for all students.
Aladin
===========
