If + ISTEXT + SEARCH

M

mldancing

I have this formula:

IF(ISNUMBER(SEARCH("A",B10)),"Apple","")

which will return Apple if the string in cell B10 contains A.

What if I want to expand the selection? Meaning if in cell B10, there is a A
or B or C, return Apple?

Cell B10 is something = A, B, C, K, Q


Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top