Results 1 to 2 of 2

Thread: FALSE statement

  1. #1

    FALSE statement



    Register for a FREE account, and/
    or Log in to avoid these ads!

    This gives me a FALSE statement. I took off the second at the end but makes no difference:


    =IF(OR(AQ2246=0,AY2246=0),"",IF(COUNTIF(AJ$2:AJ2246,AJ2246)=1,IF(ISNUMBER(SEARCH("(dr)",E2246)),"DR",IF(ISNUMBER(SEARCH("(ba)",E2246)),"BA",""))))

    Thank you all

  2. #2
    Try

    =IF(OR(AQ2246=0,AY2246=0),"",IF(NOT(COUNTIF(AJ$2:AJ2246,AJ2246)),"",IF(ISNUMBER(SEARCH("(dr)",E2246)),"DR",IF(ISNUMBER(SEARCH("(ba)",E2246)),"BA",""))))

Tags for this Thread

Posting Permissions

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