*Between*

[F. Lawrence Kulchar]

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

 

[Nigel]

"Wildcard characters" - search for this term and it provides the explanation
you require

 

[Dave Peterson]

I would test that formula once more.

Maybe you meant:

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

 

[F. Lawrence Kulchar]

Why must you use the COUNTIF function?

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

Thanks,

FLKulchar

 

[Dave Peterson]

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]

YOU ARE CORRECT...

WILDCARDS DO NOT WORK WITH...=IF(.....

Do you know why or why not?

FLKulchar

 

[Dave Peterson]

I would imagine that the developers didn't want it to.

YOU ARE CORRECT...

WILDCARDS DO NOT WORK WITH...=IF(.....

Do you know why or why not?

FLKulchar