Multiple IFs

[datadummy]

I am trying to write a statement that says if cells K2,L2,M2 = Y or NA then make cell P2=Y, but if any one of those cells = N then cell P2 = N. I have tried multiple ways and have struck out every time and am at a loss, thanks in advance!!

 

[jtakw]

Hi,

If you Only have 3 possible values (Y, N, NA) in K2, L2, M2, then you can do this:

Book1
	P
2	Y
Sheet94

Cell Formulas
Range	Formula
P2	=IF(OR(K2="N",L2="N",M2="N"),"N","Y")

 

[Eric W]

Maybe:

=IF(COUNTIF(K2:M2,"N"),"N","Y")

This just looks for an N in that range. If you actually want to validate that the cells have Y or NA, then maybe:

=IF(SUM(COUNTIF(K2:M2,{"Y","NA"}))=3,"Y","N")

 

[datadummy]

Awesome that did the trick, I appreciate the help!!!

 

[jtakw]

Glad to help.