If a cell contains a certain value
 

How can I search a cell to determine if a cell contains a certain value?
Some cells have a sentence of information and I looking for a specific work.
Does the IF function have a variation to use "contain" instead of "=" ? For
example,

=IF($A$1containsGLOBAL,1,0)

Cheers!

If a cell contains a certain value
 

Hi

This seems to work, someone else might have a better solution

=IF(ISERROR(SEARCH("GLOBAL",A1) ) = TRUE,0,1)

hth

Keith