Sorry for being not clear
If you see the first record of Alice in the attached file 3-attempt exam_3:
she got 22 in Geography ONLY in the 2nd attempt, hence, not all the conditions are TRUE for this IF statement:
[[IF(AND(E5>=50,H5>=50,K5>=50,N5>=50,Q5>=50),"Pass in 2nd attempt"]]
However, the result is [[Pass in 2nd attempt]]!! Of course it is correct.
But how, while NOT all the conditions are met, as it is supposed with AND function?!
The other question is:
As I distributed the file for other classes' teachers, I phased that some teachers do not have the same number of subjects; some have 4, others have 5.
The problem is when they deleted the unneeded column (History subject) the Final Result function gives #REF!
How to overcome this problem automatically?
I mean, how to delete #REF! from the function automatically?
Please, see the attached file 3-attempt exam_4
Thanks for your patience.
|