If + ISTEXT + SEARCH
 

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.

Answer: If + ISTEXT + SEARCH
 

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.

If + ISTEXT + 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.

If + ISTEXT + SEARCH
 

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.

If + ISTEXT + SEARCH
 

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.