Multiple IF statments

[datadummy]

I am trying to write a statement with multiple IF's and am coming up short and getting #VALUE response. Here is my current statement,

=IF(F140="Y","","NA")*OR(IF(F140="N","Y","NA"))

I am assuming that I have something conflicting but am not sure what. Any suggestions?

 

[Joe4]

Is this what you are after (try it and see if it returns what you want):

[COLOR=#574123]=IF(F140="Y","",IF(F140="N","Y","NA"))[/COLOR]

If not, please explain the exact logic you want implemented (in plain English).

 

[datadummy]

I think that did the trick. Thank you!!

 

[Joe4]

You are welcome!

Here is a write-up on Nested IF statements that help explains how they work: https://support.office.com/en-us/ar...pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8