If contains

C

CF

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"
 
P

Pete_UK

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
 
R

RagDyeR

Try this:

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

--

HTH,

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

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"
 
N

Natalie

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..
 
Top