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.
