Multiple Condition IF/OR Statement with TEXT
Results 1 to 2 of 2

Thread: Multiple Condition IF/OR Statement with TEXT
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2018
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple Condition IF/OR Statement with TEXT

    I am trying to return “Address” if late entry code does NOTcontain “yes” (preferably not case sensitive), OR if the very last column,outsource PO # = 0. If neither of those conditions are met, I would like toreturn “Clear.” I have responses for all based on this formula:

    =IF(OR(AM51 = 0, C51 <> "yes"),"Address", "Clear")
    However, it is returning “Address” to some that should beclear. I think this is because I need to do either a FIND or SEARCH function tosupport the OR clause. Can anyone please advise?




    Date Entered Late Entry Code Stock Location Order Number Bill-to Name qty open Part Number Anticipated Ship Date Outsource PO #

    1/21/201 9 29908 29909 YES Address DFTDN2 498362 NO CHARGE/REPLACEMENTS 2 APRS18UNIT2 1/31/2019 0

  2. #2
    Board Regular
    Join Date
    Oct 2014
    Location
    UK
    Posts
    3,826
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Multiple Condition IF/OR Statement with TEXT

    try

    =IF(OR(AM51 = 0, NOT(ISNUMBER(SEARCH("yes",C51)))),"Address", "Clear")

Some videos you may like

User Tag List

Tags for this Thread

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
  •