If contains

Giganews Newsgroups
Subject: If contains
Posted by:  CF
Date: Wed, 3 May 2006

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"

Replies