Thanks a million

To clear the problem here is the scenario:
There are two grades (7 & 8) in my school.
Grade 7 has 4 subjects and grade 8 has 5 subjects.
I have to create one Excel sheet for both grades.
I have made one with 5 subjects for grade 8 with all its functions.

When I used this file for grade 7 (which has 4 subjects), I have to delete the column number 5 (the 5th subject), right!

The problem is:
#REF! appears in the functions as below:
=IF(AND(E4>=50,H4>=50,K4>=50,N4>=50,#REF!>=50),"Pass in 1st attempt",IF(AND(E5>=50,H5>=50,K5>=50,N5>=50,#REF!>=50),"Pass in 2nd attempt",IF(AND(E6>=50,H6>=50,K6>=50,N6>=50,#REF!>=50),"Pass in 3rd attempt","")))

as in the attached file.

The question is:
How to delete or overcome this (#REF!) automatically?
Notice, please, that I will use this file for more different grades.

I hope it is clear now.
And sorry for ambiguity.

Accept my respect.

Attached Files

3-attempt exam_4.xlsx (13.5 KB, 9 views)