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")
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")
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")
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 *
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks