Cells containt text of multiple words. I want to return "Yes" if "A" exists in cell; "No" if "B" exists; and "maybe" if neither A or B exists... ? Currently, I'm using =IF((ISNUMBER(SEARCH("A",B3))),"YES","NO") ...but this only tells me about A not B or neither ??
Welcome to the forum.
Maybe ...
=CHOOSE(2*ISNUMBER(SEARCH("A", A1)) + ISNUMBER(SEARCH("B", A1)) + 1, "Neither", "B", "A", "Both")
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks