Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to use multiple IF and OR
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 |
#2
|
|||
|
|||
Is it possible to use multiple IF and OR
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. |
#3
|
|||
|
|||
Is it possible to use multiple IF and OR
Thanks Dave that did the trick alright. I never would have thought of it
backwards like that! "Dave O" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |