Thread: String of data in a cell. Want to use 'contains' in an 'if' statem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
  
Posts: 358
Default String of data in a cell. Want to use 'contains' in an 'if' statem
Is there a way of writing the following?

=if ( cell 'contains' x , then write "y" , else write "n" )
The cell contains text.

Suggestions appreciated, thanks.
Reply With QuoteReply With Quote