Try this:

=6-COUNTIF(K1,"*AB*")

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Colin Hayes" wrote in message
...


HI

I'm using this formula :

=IF(K1="AB",5,6)

This places a number 5 in the target column if K1 contains the letters
"AB" , and a 6 if it doesn't.

The problem is that it only works for if the content is *exactly* "AB". If
there is any other content in the cell , it returns a false conclusion.

What I really need is for this to work if the letters "AB" are contained
*anywhere* within the text in K1.

Is this possible?

Grateful for any help.