You don't _have_ to.

But it's one way of determining if honda is in A1 (even if it's surrounded by
other characters).

You could also use:
=if(isnumber(search("honda",a1)),"there","not there")

Change "search" to "find" if case is important.

But wildcards won't work in this:

=If(A1="*honda*", ....



F. Lawrence Kulchar wrote:

Why must you use the COUNTIF function?

Why NOT...=IF(A1="*honda*","there","not there")

Thanks,

FLKulchar

"Dave Peterson" wrote:

I would test that formula once more.

Maybe you meant:

=if(countif(a1,"*honda*")0,"is there","not there")



F. Lawrence Kulchar wrote:

I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the
word..."honda" anywhere within the text, etc., etc.

I was explained this yesterday...

HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS??

Thanks,

FLKulchar

--

Dave Peterson


--

Dave Peterson