=if(isnumber(search("jump",a1)),true,false)

or even:
=isnumber(search("jump",a1))


Kel wrote:

Hi all!!!

Im trying to figure how in a "IF formula" you do the following,
Also i would like to have it for VB.
Thanx

IF(A1 CONTAINS (beetween other words) jump,TRUE,FALSE

say A1 contains text like this "i like to jump to the roof" or "to the roof
i lilke to jump" not in a particular position, return cell B1 to say "NO"

Thank you all.

--

Dave Peterson