If a cell contains a certain value

G

Guest

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!
 
K

Keith74

Hi

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

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

hth

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel If a Cell Contains a Certain Text (From Another Table) 0
Function to determine if a cell contains a formula 5
Functions 1
Is there such a thing as a contains formula 7
Count If value 10
When a cell contains a certain value 5
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
IF question 2

Top