#HREF! problem when I delete a row

[Guest]

I have a formula than contains several cells check such as :
=IF(ANDB11<>"n.a.",B12<>"n.a.",B13<>"n.a.",B11>=B12,B12>=B13),"OK",IF(AND(B11="n.a.",B12>=B13),"OK",IF(AND(B12="n.a.",B11>=B13),"OK",IF(AND(B13="n.a.",B11>=B12),"OK","NO"))))

I want to be able to delete one row, let's say 11 or 12 and don't get any #REF! problem after that. Meaning I would like to more reference to those cells in my formula. Blank instead of #REF! error...

Olivier

 

[Guest]

I had the same problem and I would like to find an answer !