Is it possible to write an IF function with the operator "contains"

IF cell X contains "hello" then "YES" otherwise "no"

Cell X = "Yo hello yo" - function returns "YES"

There isn't a "contains" function or operator, but you can test for the
occurrence of one string in another by means of SEARCH( ) or FIND( ) -
FIND is case-sensitive.

Hope this helps.

Pete

If you use the logical IF function wizard you will be able to enter your cell
range and criteria with a returns Yes if true and No if not true..
--
Natalie


"CF" wrote:

Is it possible to write an IF function with the operator "contains"

IF cell X contains "hello" then "YES" otherwise "no"

Cell X = "Yo hello yo" - function returns "YES"

Try this:

=IF(ISNUMBER(SEARCH("hello",A1)),"Yes","No")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CF" wrote in message
...
Is it possible to write an IF function with the operator "contains"

IF cell X contains "hello" then "YES" otherwise "no"

Cell X = "Yo hello yo" - function returns "YES"

Works!

thank you.

"RagDyeR" skrev:

Try this:

=IF(ISNUMBER(SEARCH("hello",A1)),"Yes","No")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CF" wrote in message
...
Is it possible to write an IF function with the operator "contains"

IF cell X contains "hello" then "YES" otherwise "no"

Cell X = "Yo hello yo" - function returns "YES"

One mo

=if(countif(a1,"*hello*")0,"Yes","No")

CF wrote:

Is it possible to write an IF function with the operator "contains"

IF cell X contains "hello" then "YES" otherwise "no"

Cell X = "Yo hello yo" - function returns "YES"

--

Dave Peterson