IF Formula - 4 cases Possible ?

[audrey]

Hello,

I am trying to figure out a relatively complicated IF formula

the logic is as follows

IF A1 is 0 and B1 is 0 Type "OK"
IF A1 has a value and B1 is 0 "Not OK"
IF B1 has a value and A1 is 0 "Not OK"
IF A1 has a value and B1 has value "OK"

is it possible to put this 4 cases in one IF formula ?

 

[VoG]

Try

=IF(OR(AND(A1=0,B1=0),AND(A1<>0,B1<>0)),"OK","Not OK")

 

[JackDanIce]

Try:

=IF(OR(AND(A1=0,B1=0),AND(A1<>0,B1<>0)),"OK","Not OK")

 

[audrey]

both works perfectly thanks guys

 

[jasonb75]

A late alternative

=IF(COUNTIF(A1:B1,0)=1,"Not OK","OK")