View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cynichromantique
 
Posts: n/a
Default Help writing an IF statement

I would like to write an IF statement that would put an asterick in a
specific column of the same row where any text residing in Column A matches
specific text.

Example:

Column A of Row 125 contains the text "top rated auto insurance". I would
like for the IF statement to test for the word "insurance" and place an
asterick in Cell I125.

Thanks!