View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] hasnatcet@gmail.com is offline
external usenet poster
 
Posts: 1
Default IF cell contains certain text return value

On Tuesday, June 30, 2009 at 4:38:01 PM UTC+7, Jacob Skaria wrote:
If this is one cell
try
=IF(COUNTIF(A1,"*check*"),"Checking","Doing")

Since you mentioned row...try the below as well It checks for these words in
Cols A to J for the first row. Copy down as required.
=IF(COUNTIF(A1:J1,"*check*"),"Checking","Doing")

If this post helps click Yes
---------------
Jacob Skaria


"Eán" wrote:

I have a row containing various text including the words 'Check' &
'Checking'; in a separate row I would like to identify all the cells which
include 'Check' or 'Checking' and return the text "Checking" if it contains
either 'Check' or 'Checking' or "Doing" if it doesn't.
Hope this makes sense?
Many thanks


what should I do, when I have to find 2 different texts ?