Results 1 to 11 of 11

Excel 2007 : If formula in combination with OR, AND and LOWER

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Kiel, Gemrany
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question If formula in combination with OR, AND and LOWER

    Hello everybody,

    I have a problem figuring out how to make a statement work.
    The situation is the following:

    I have several cells filled with single words. Lets say:
    A1=hello
    A2=wonderful
    A3=world

    Then I have several other fields filled with sentences e.g.:
    B1=Mr. Smith says: "Hello!"
    B2=The world is wonderful.
    B3=Hello wonderful world.

    Now I would like to have two results.

    1. First of all a condition where one of the criteria is met: one of the three fields A1, A2, A3 is found in B1, B2 or B3.

    I would suggest something like:
    =IF(ISERROR(FIND(OR(LOWER(A1;A2;A3));OR(LOWER(B1;B2;B3));1));"No";"Yes")

    The LOWER is used to be sure that we have the same letter case as we know that FIND is case sensitive. This example keeps saying that I have entered too many arguments. I am sure that there is something wrong with my syntax.

    1. Second Condition would be. Detect if in one sentence all keywords A1, A2, A3 appear.

    My Idea that does not work:
    =IF(ISERROR(FIND(OR(LOWER(A1;A2;A3));LOWER(B1);1));"No";"Yes")

    Same error.

    Thanks for your help in advance!
    Last edited by raytray; 09-14-2011 at 04:35 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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