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!