Simple "if word exist among theese cells, then true"

J

JemyM

Im banging my head on the "find" functions. They give me a -value- when
I need TRUE/FALSE for an IF function.
It must be a much easier way to return TRUE or FALSE if a word exist
within an area:

Data:
A1: Orange
A2: Apple
A3: Banana

Function:
1: Is "*Apple*" in A1:A3? = TRUE!
2: Is "*Tomato*" in A1:A3? = FALSE!
 
B

Bob Phillips

=COUNTIF(A1:A3,"*Apple*")>0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

Similar Threads

COUNTIF text where there is more than one word in a cell 2
How to verify that 3 cells are equal 4
range between cells 1
IF statement with lists and dropdowns 1
Referencing Multiple Cells with Nested IF statements? 1
comparing a value to a list 1
Need a macro to do this... 1
search range, if exist, copy cell 2

Top