SPS looks like

ColA ColB ColC ColD ColE ColF
N N N N N N
N N N Y
Y N N
N N

I need to create a new column that says if there is only N's OR blanks in
any row from Col A-F, put a Y, so in the example above ColG would have a Y in
rows 1 and 4.

Is this doable with IF/OR/AND?

Thanks
Lynn