Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: #HREF! problem when I delete a row

  1. #1
    Guest

    Default

    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

  2. #2
    Guest

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •