IF cell contains / does not contain

[surkdidat]

Apologies

My brain is not working this Monday morning!

Can someone please help and translate the following into a formula

IF B1 CONTAINS "cat" AND c14= "CR" then display "NA",

IF B1 CONTAINS "dog" AND c9 DOES NOT CONTAIN "dog", then display "NA"

Otherwise display "1"

Many thanks

 

[snjpverma]

Your question is not clear in Post # 9.

try if this works for you

=IF(OR(AND(ISNUMBER(SEARCH("cat",B1)),C14="CR",ISERR(SEARCH(B1,C9))),AND(ISNUMBER(SEARCH("dog",B1)),ISERR(SEARCH("dog",C9)))),"NA",1)

 

[surkdidat]

Hi

To clarify:-

Where I have the formula

=IF(OR(AND(ISNUMBER(SEARCH("cat",B1)),C14="CR"),AND(ISNUMBER(SEARCH("dog",B1)),ISERR(SEARCH("dog",C9)))),"NA",1)

This works perfectly, apart from I forgot part of my logic!

Into the above formula, I need it to also look at cell C9. In this cell will be a word, such as "Flap". I then need it to look in B1 and see if it contains "CAT" and also the value of c9. If it contains BOTH, I need it to return a "1" value. If it contains "CAT" in B1, and anything other than the text in C9, I want it to return "NA".

I did try the following code, but it reverses the result, ie returns a ! winstead of a "NA", and a "NA" instead of a "1"

AND(ISNUMBER(SEARCH($I$13,B1)),ISERR(SEARCH(B1,$I$13)))),

Your question is not clear in Post # 9.

try if this works for you

=IF(OR(AND(ISNUMBER(SEARCH("cat",B1)),C14="CR",ISERR(SEARCH(B1,C9))),AND(ISNUMBER(SEARCH("dog",B1)),ISERR(SEARCH("dog",C9)))),"NA",1)