Making the AND function look at only part of a cell entry

[Cathy]

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.

 

[Barb Reinhardt]

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

 

[Cathy]

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