AND or OR

[montanaaggie]

In cell A1: I want to have an equation that will display the value in G1 if meets one of the two conditions. If it doesn't I want it to display a 0.


1): B1="Yes"
or
2): C1="Yes" and D1="Yes"


I tried in A1 the following: =IF(AND(B1="yes",OR(C1="yes",D1="yes")),G1,0)
That doesn't appear to generate the expected returning. Meaning B1 did say yes, but it still populated a 0 for A1

 

[MrKowz]

Just a slight bit off on your nests:

=IF(OR(B1="Yes",AND(C1="Yes","D1="Yes")),G1,0)

 

[danzon]

try

=IF(OR(B1="Yes",AND(C1="yes",D1="Yes")),G1,0)

 

[Scott Huish]

=g1*or(b1="yes",and(c1="yes",d1="yes"))