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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top