View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default an if( statement looking for a specific phrase anywhere in a cell

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

--
HTH

Bob Phillips

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

"ozarksons" wrote in message
...
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.