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.