|
|
|
|
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:
- =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:
- =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.
__________________
I am not human. I am an Excel Wizard
|