Nested IF Formula

[Lmsloman]

Good Morning Everyone!

I am just beginning to dabble in nested IF statements and so far, I think I've done a pretty bang up job....however, when there is text involved, I seem to get myself confused.

Here is my formula:

=IF(AND(D25="Y",G25="Y",J25="Y"), "Y", "N")

This works just fine, because I want it to return a "Y" if those 3 cells equal "Y", or to return a "N" if they don't.....

However, I would like to take it a step further to ALSO return an "N/A" if the value in one of those cells equals "N/A".

*The N/A has been manually entered and is not the result of a formula error

So basically, to break it down:

IF D25, G25, and J25 ALL equal "Y", then return "Y" in that cell...if any of them contain an "N", return "N" in that cell.....or.... IF ANY of those cells equal "N/A", then return "N/A" in that cell.

Does this make sense?

Thank you in advance for reviewing my questions!

-Peace!

[dcgrove]

Try this,

=if(or(d25="N/A,g25="n/A",j25="N/A"),"N/A",IF(AND(D25="Y",G25="Y",J25="Y"), "Y", "N")

[Lmsloman]

Try this,

=if(or(d25="N/A,g25="n/A",j25="N/A"),"N/A",IF(AND(D25="Y",G25="Y",J25="Y"), "Y", "N")

I got an error with this formula.....

[dcgrove]

Try this one.

=IF(OR(D25="N/A",G25="N/A",J25="N/A"),"N/A",IF(AND(D25="Y",G25="Y",J25="Y"),"Y","N"))

[Lmsloman]

It worked! Thank you so much!

[dcgrove]

Glad it worked for you!