an if( statement looking for a specific phrase anywhere in a cell

B

Bob Phillips

=IF(ISNUMBER(SEARCH(A1,"abc")),"found","not found")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
O

ozarksons

I want to have an if( statement evaluate a cell and see if it contains a
certain text word or phrase, anywhere in the cell, and if so perform x , if
not y.
 
O

ozarksons

Great answer, thanks except you had it backwards...
=IF(ISNUMBER(SEARCH("abc",A1)),"found","not found")
 
B

Bob Phillips

I keep getting that wrong <g>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

if function and ifblank() function 3
How do I count cells with a specific cell shading? 3
Removing 1-2 caharacters 1
Count based on string in cell 1
Search OF Macros for a specific phrase 2
what is the formula to convert 5513 seconds into minutes 00:00:00 2
How to calculate time after converting 12.22 to 12:22 1
Nested IF functions beyond eight items? 3

Top