Thread: If contains
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CF
 
Posts: n/a
Default If contains

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"