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.

To expand the selection and return "Apple" if cell B10 contains A, B, or C, you can modify the formula using the OR function. Here's how you can do it:

1. =IF(OR(ISNUMBER(SEARCH("A",B10)),ISNUMBER(SEARCH(" B",B10)),ISNUMBER(SEARCH("C",B10))),"Apple","")

This formula uses the OR function to check if any of the conditions are true. The conditions are the same as the original formula, but we added two more conditions for B and C. If any of these conditions are true, the formula will return "Apple". If none of the conditions are true, the formula will return an empty string ("").

You can also simplify the formula by using the FIND function instead of SEARCH. The FIND function is case-sensitive, so it will only find exact matches. Here's the simplified formula:

1. =IF(OR(ISNUMBER(FIND("A",B10)),ISNUMBER(FIND("B",B 10)),ISNUMBER(FIND("C",B10))),"Apple","")

This formula works the same way as the previous one, but it uses the FIND function instead of SEARCH.

Try this:

=IF(COUNT(SEARCH({"A","B","C"},B10)),"Apple","")

--
Biff
Microsoft Excel MVP


"mldancing" wrote in message
...
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.

It works!! Thank you very much!!


"T. Valko" wrote:

Try this:

=IF(COUNT(SEARCH({"A","B","C"},B10)),"Apple","")

--
Biff
Microsoft Excel MVP


"mldancing" wrote in message
...
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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"mldancing" wrote in message
...
It works!! Thank you very much!!


"T. Valko" wrote:

Try this:

=IF(COUNT(SEARCH({"A","B","C"},B10)),"Apple","")

--
Biff
Microsoft Excel MVP


"mldancing" wrote in message
...
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.