If/Then Formula

[jnelson]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a column of cells that contain yes or no answers. What I need to do is write a formula that will result in a summary cell that answers "yes" if all of the above cells say yes or answers "no" if any of the cells above say no.

 

[Bob Greenblatt]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel I have a column of cells that contain yes or no answers. What I
need to do is write a formula that will result in a summary cell that
answers "yes" if all of the above cells say yes or answers "no" if any
of the cells above say no.

assuming the range is A1:A100, use the following formula:
=if(and(a1:a100="yes"),"yes","no")
press control-shift-enter to array enter the formula If done correctly,
the formula will appear surrounded by brackets { } in the formula bar.
Do NOT enter the brackets.

 

[jnelson]

Thanks Bob. So here is the modified formula i am using:

=IF(AND(B4:B13,B15:B17="Yes&quot,"Yes","No&quot

What it seems to be doing is only evaluating the last series for "yes" and ignoring the responses in the first series altogether. I need to plug in 2 series with headers in between so I can't just do a single series.

Any thoughts?

 

[CyberTaz]

You need for 2 conditions to be tested so you need to state the complete
expression for each condition. Try:

=IF(AND(B4:B13="yes",B15:B17="Yes"),"Yes","No")

HTH |:>)
Bob Jones
[MVP] Office:Mac