Boolean Operaters to equal 'Contained Within'
=IF(OR(COUNTIF(K1,"*AB*"),COUNTIF(K1,"*CD*")),5,6)
On Feb 8, 1:45 pm, Colin Hayes wrote:
In article , Lori
writes
=IF(COUNTIF(K1,"*AB*"),5,6)
Hi
OK thanks for that. Worked perfectly , first time.
Out of interest , could this formula be extended to include a second
criterion so that it would check if "AB" OR "CD" were present before
giving the true or false conclusion?
Thanks again.
"Colin Hayes" wrote:
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.
|