#HREF! problem when I delete a row

Mar 5th, 2002, 02:38 PM

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

Mar 5th, 2002, 03:04 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 02:38 PM	#1
Guest Posts: n/a	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

Mar 5th, 2002, 03:04 PM	#2
Guest Posts: n/a	I had the same problem and I would like to find an answer !