Thanks very much. I combined search and isnumber and it works perfectly now.

"Barb Reinhardt" wrote:

Try using the search function. If the value is 0, it's found the text your
looking for.
--
HTH,

Barb Reinhardt



"Cathy" wrote:

I am trying to identify different conditions that might exist with data using
an AND statement embedded in an IF statement. The cell entries in column K
might contain the word "composite", but there will be many times when the
cell will have other words as well, e.g. Composite class/Multi-managed.

I've looked at other posts on the board and tried various wild card-type
solutions but can't find a way to make the AND statement look at only part of
the cell.

=IF(AND(G2="dupe",I2="x"),"delete",IF(AND(G2="dupe ",K2="composite"),"delete",IF(N2="y","delete","")) )

Help would be much appreciated! Thanks.