IF statment

[datadummy]

Looking for assistance with an IF statement, what I am trying to do is say if cell I2 or J2 = Y than K2 should be Y if either cell is N then K2 should be N.

 

[jtakw]

Hi,

Can one of I2 or J2 have Y and the other have N at the same time?

 

[Joe4]

So, what happens if one is "Y" and one is "N"?
Which one wins?

 

[datadummy]

Either I2 or J2 can be Y and the other will be N or both will be N in which case K2 should be N. As long as one has Y then K2 should be Y.

 

[jtakw]

Can I2 and J2 both be empty/blank?

As it is, the formula will result in "N"

Book1
	I	J	K
2	Y		Y
Sheet165

Cell Formulas
Range	Formula
K2	=IF(OR(I2="Y",J2="Y"),"Y","N")

 

[datadummy]

Bingo! I knew it had to be something remotely easy, thanks for your help!!

 

[jtakw]

You're welcome, glad to help.

 

[datadummy]

would it be possible to take it one step further and say if either cell is blank then leave K2 blank until I2 and J2 is populated?

 

[Joe4]

Yes, just wrap the function that jtkaw gave you in another nested if.

[COLOR=#333333]=IF(OR(I2="",J2=""),"",IF([/COLOR][COLOR=Blue]OR([COLOR=Red]I2="Y",J2="Y"[/COLOR]),"Y","N"[/COLOR][COLOR=#333333]))[/COLOR]

 

[datadummy]

BOOM, you guys rock!!! Thanks for the help that was awesome!!