conditional values

[tmacke]

I have three columns, each has a yes or no question that needs a
response in rows 1 - 1000. (a "1" if yes, or a "2" if no). If any of
the three questions is answered with a "1", I need to populate another
column (labeled "Action Required") with either "Yes" or "No". The only
time the "Action Required" will be "No" is when all the questions
contain "2" as the response.
if any one of the questions contains a "1" I need the "Action Required"
to be "yes.

Does anyone have a solutiion to this problem?

thanks in advance

 

[davesexcel]

start with
=If(A1=1,"Yes","No")
change the A1 to where ever the answer is,
for this example copy and paste the formula in B1
enter 1 in A1 and see what happens, what happens when you enter
2

 

[Guest]

Hi

Try something like this in D2 (Action required):
=IF(AND(A2=2,B2=2,C2=2),"No","Yes")

If your 1s and 2s are actually text (which they may be because you used "1"
in your exmaple, use this option:
=IF(AND(A2=2,B2=2,C2=2),"No","Yes")

Hope this helps.
Andy.

 

[Pete_UK]

Assume the three columns with the yes/no replies occupy B, C and D,
starting on row 2, then in your Action Required column cell 2 add this
formula:

=IF(OR(B2=1,C2=1,D2=1),"Yes",IF(AND(B2=2,C2=2,D2=2),"No","n/a"))

You don't specify what you want if the conditions are not met (eg blank
cells) - this returns "n/a" in this situation.

Copy the formula down your Action Required column for as many rows as
you have data.

Hope this helps.

Pete

 

[tmacke]

thanks for your response, but I'm not sure that I understand. The
"Action Required" is based on the response to all three questions. If
the responses in cells A2, B2 and C2 are all "2" (No), the the "Action
Required" cell in D2 should be "NO", but if any of the responses in A2,
B2 and C2 is "1" (yes), then the Action required needs to be "YES"

Is this a little more clear?

 

[tmacke]

this works, thanks for the advice

 

[DJH]

if(max(a1:a3)=2,"NO","YES)