FIND Function: Possible to return True or False?

[McStagger]

Hello!

I am using FIND to search for a specific letter in a small string which will be used to facilitate some conditional formatting. Is it possible to have FIND return a TRUE or FALSE rather than the character position in which said letter is in the string?

For example, if I have the string "25.5%BE", FIND currently returns a 6 if I look for "B". I just need a TRUE or FALSE.

Thank you!

[Phuocam]

Try this ...

=ISNUMBER(FIND("B","25.5%BE"))

[JohnTopley]

Try

=ISNUMBER(SEARCH("B",A1))

[sandy666]

=IFERROR(FIND(7,M9)>0,FALSE) adjust references accordingly

[McStagger]

Thanks guys!

[Tony Valko]

Here's another one...

=COUNTIF(A1,"*B*")>0

Note that this is not case sensitive.