Checking for #N/A value in nested IF statement

[PNY80]

Hello!

I'm using a nested IF statement and calculating values based on the data in adjacent cells. I basically want part of my formula to do this check: If this cell isn't equal to #N/A, then display a certain value. Right now, my formula looks like this:

=IF(AND(ISNA(K35),L35="N/A",ISNA(M35)),"VALUE X",IF(AND(K35<>ISNA(K35), L35<>"N/A",ISNA(M35)),"VALUE Y","VALUE Z"))

.. but it isn't working. I've bolded the circular argument (which I'm assuming is what is giving me the problem).

Please let me know what I'm doing wrong.

Thank you!

 

[Scott R]

Right now, my formula looks like this:

=IF(AND(ISNA(K35),L35="N/A",ISNA(M35)),"VALUE X",IF(AND(K35<>ISNA(K35), L35<>"N/A",ISNA(M35)),"VALUE Y","VALUE Z"))

Would NOT(ISNA(K35)) do it?