Thread: IF - looking in a cell for a specific value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
  
Posts: 128
Default IF - looking in a cell for a specific value
In an IF statement, what do I need to write to say that if cell A1 contains
"fred", (i.e. " * fred * ") then.. "Yes".
(I'm not sure what operator is needed to say 'contains')

Any ideas?
Reply With QuoteReply With Quote