IF with 3 conditions

[Mr2017]

Hi

I'd like to write a formula that

i) checks that J1 is not blank
i) checks if the word "for" is NOT in a cell J1
ii) checks if cell K1 is equal to 0.

I've tried this formula but it's not returning the result expected.

=IF(AND(J1<>"",K1=0,COUNTIF(J1,"*for*")),"Code","Blank")

Please assume that the word "for" is in cell J1 and the value in K1 is 0.


The word "code" should appear ONLY IF cell J1 has a 0 AND cell K1 does NOT have the word "for"

But it's still appearing. Does anyone know why?

Thanks in advance.

 

[njimack]

=IF(AND(J1<>"",ISERROR(SEARCH("for",J1)),K1=0),"Code","Blank")

 

[Fluff]

Maybe
=IF(AND(J1<>"",K1=0,COUNTIF(J1,"*for*")=0),"Code","Blank")

 

[Mr2017]

Amazing!! Thank you both!!

 

[Fluff]

You're welcome & thanks for the feedback