Using AND and OR together

[spiffmonkey1]

Hi,

I have a column D. I want a cell(D67) to change to "yes" when cells D69,D71,D72 OR D73 equals "yes" AND when D69,D71,D72 OR D73 equals "yes".

So what I have is-
=IF(OR(D69="yes",D71="yes",D72="yes",D73="yes")*AND(OR(D69="yes",D71="yes",D72="yes",D73="yes")*),"yes","no")

Thanks

 

[diddi]

=IF(AND(OR(D69="yes",D71="yes",D72="yes",D73="yes"),OR(D69="yes",D71="yes",D72="yes",D73="yes")),"yes","no")

 

[Comfy]

I dont quite understand but if you want to display yes if two or more cells say yes then:

=IF(COUNTIF(D69:D73,"yes")>=2,"Yes","No")

 

[MrKowz]

Isn't this redundant? You are stating the same condition twice in the AND statement.

Are you looking for when "Yes" appears twice in that range you defined?

 

[spiffmonkey1]

Thank you!
There is still one problem though
The way the code is written, if I make D69="yes" and the other cells "no" it will still make D67="yes". I want it so that it doesn't like allow repetition of a cell so there has to be two different cells that say "yes".
I don't know if you understand what i said :/

Thanks Comfy
SOLVED

 

[Marcelo Branco]

Maybe i'm missing something, but the two conditions seems to be identical, so why do you need the AND?

M.

 

[MrKowz]

Thank you!
There is still one problem though
The way the code is written, if I make D69="yes" and the other cells "no" it will still make D67="yes". I want it so that it doesn't like allow repetition of a cell so there has to be two different cells that say "yes".
I don't know if you understand what i said :/

What Comfy posted should work for you.

 

[Comfy]

Please see my previous post

 

[spiffmonkey1]

Ok I have another question
So for example when cell D69="yes", D67="yes"
BUT if D69="yes" and D70="yes", D67 would still ="yes"
So what I'm saying is the rules still stack
How do I make it so that ONLY if one cell="yes", then D67 would ="yes"

Thanks again

 

[MrKowz]

Try:

=IF(COUNTIF(D69:D73,"yes")=1,"Yes","No")