+ Reply to Thread
Results 1 to 7 of 7

IF and or function

  1. #1
    Registered User
    Join Date
    11-21-2021
    Location
    New York
    MS-Off Ver
    2019 and also have 365
    Posts
    23

    IF and or function

    I have 4 columns; I need to find the following
    Column A
    A2 If response is either Yellow, Gold or Orange
    Column B
    B2 If text contains “Shirt”
    Column C
    C2 If text does NOT contain “Apple”
    Column D
    D2 Text is equal to YES

    I would like to know if they are a MATCH, NOT a Match

    Please let me know if you need any more information, thanks

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,005

    Re: IF and or function

    A sample file, with representative examples and expected answers is often a more useful starting point... but try:

    =IF(AND(OR(A2={"Yellow","Gold","Orange"}),ISNUMBER(SEARCH("Shirt",B2)),ISERROR(SEARCH("apple",C2)),D2="Yes"),"Match","No")
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    11-21-2021
    Location
    New York
    MS-Off Ver
    2019 and also have 365
    Posts
    23

    Re: IF and or function

    Thank you, I will try and let you know the results. Have a great day!

  4. #4
    Registered User
    Join Date
    11-21-2021
    Location
    New York
    MS-Off Ver
    2019 and also have 365
    Posts
    23

    Re: IF and or function

    It did not work when I put in all that should be a match
    Attached Files Attached Files

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,005

    Re: IF and or function

    Sorry, I just saw your reply. In your opening post you said:

    NOT contain “Apple”
    =IF(AND(OR(A2={"Yellow","Gold","Orange"}),ISNUMBER(SEARCH("Shirt",B2)),ISERROR(SEARCH("apple",C2)),D2="Yes"),"Match","No")
    (my original formula)

    In the header to column C in your recent attachment you said:

    contain “Apple
    =IF(AND(OR(A2={"Yellow","Gold","Orange"}),ISNUMBER(SEARCH("Shirt",B2)),ISNUMBER(SEARCH("apple",C2)),D2="Yes"),"Match","No")


    which do you want?

    If neither of these are correct, add a few more samples and INCLUDE your expected answers.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-21-2021
    Location
    New York
    MS-Off Ver
    2019 and also have 365
    Posts
    23

    Re: IF and or function

    Thank you so much, this works great! Have a wonderful weekend.

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,005

    Re: IF and or function

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Right function, Left function, Mid function to extract values in column A
    By bjnockle in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-14-2020, 03:14 PM
  2. COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2018, 05:27 AM
  3. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  4. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  5. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  6. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  7. Replies: 2
    Last Post: 03-20-2009, 01:29 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1