Is it possible to use multiple IF and OR

L

Lynn Bales

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
 
D

Dave O

Hi, Lynn-
You could count the Ns and blanks; the opposite way to think of that
same scenario is the absence of Ys. If you like that logic, you can
use the formula
=IF(COUNTIF(A1:F1,"Y")=0,"Y","")
.... to put a Y in column G.
 
L

Lynn Bales

Thanks Dave that did the trick alright. I never would have thought of it
backwards like that!
 
Top