Complex IF AND OR statement

Hello,

I am trying to write a statement that will output "ERROR" if any cell L, K or J has a value in it, while any cell L, K or J in the same row is blank. The statement below works if only L, J or K is filled. It works if J and K are filled and L is blank and if J and L are filled but K is blank. However, if only K and L are filled and J is blank it outputs "OK".

Can anyone tell me where I have gone wrong?

=IF(AND($K4<=180,$K4>=0,$L4<=180,$L4>=0,$L4>$K4,$K4>$L3),"OK",IF(AND($L4="",$K4="",$J4=""),"",IF(OR($L4>=0,$K4>=0,$J4>=0,OR(AND($L4="",$K4="",$J4=""))),"ERROR","")))

See attached example.

Thanks!

That works better...but I need it to output a blank cell if all three of them are blank and an error if one or two are filled but not the other(s)

IF(AND($L4="",$K4="",$J4=""),"",IF(OR($L4>=0,$K4>=0,$J4>=0,OR(AND($L4="",$K4="",$J4=""))),"ERROR","")))))

which is that part of the formula.

Any ideas?

Thank you very much. I had to add a count to the first part of my statement also.

=IF(AND($K4<=180,$K4>=0,$L4<=180,$L4>=0,$L4>$K4,$K4>$L3,COUNT(J4:L4)=3),"OK",IF(COUNT(J4:L4)=3,"OK",IF(COUNT(J4:L4)=0,"","ERROR")))