+ Reply to Thread
Results 1 to 4 of 4

=IF(AND(ISNUMBER(SEARCH not getting the desired result

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    4

    =IF(AND(ISNUMBER(SEARCH not getting the desired result

    Hi,

    both cells C7 and C8 contain the correct "Y" yet I'm still getting "N" as a result. Any ideas why this is?

    You're help is most appreciated.

    =IF(AND(ISNUMBER(SEARCH("Y",C7,)))*ISNUMBER(SEARCH("Y",C8)),"Y","N")

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: =IF(AND(ISNUMBER(SEARCH not getting the desired result

    adopt brackets:

    =IF(AND(ISNUMBER(SEARCH("Y",C7,))*ISNUMBER(SEARCH("Y",C8))),"Y","N")

    but also you can remove AND
    =IF(ISNUMBER(SEARCH("Y",C7,))*ISNUMBER(SEARCH("Y",C8)),"Y","N")

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: =IF(AND(ISNUMBER(SEARCH not getting the desired result

    Another way..

    =LOOKUP(ISNUMBER(SEARCH("Y",C7))*ISNUMBER(SEARCH("Y",C8)),{0,1},{"N","Y"})
    or shorter
    =IF(ISNUMBER(SEARCH("Y",C7))*ISNUMBER(SEARCH("Y",C8))=1,"Y","N")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    08-29-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: =IF(AND(ISNUMBER(SEARCH not getting the desired result

    Fantastic,

    =IF(ISNUMBER(SEARCH("Y",C7))*ISNUMBER(SEARCH("Y",C8))=1,"Y","N") Did the trick.

    Ace / Zbor thank you very much for your time and help.

    Zackie

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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