• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Excel Formula

R

rod411

New Member
I am having difficulty inputting the correct formula for the following project I need.

Here goes:

If A2 is "Yes" and B2 or C2 are "Yes" THEN D2 is "Yes"

AND If A2 is "Yes" and if B2 and C2 are "Yes" THEN D2 is "Yes"

AND if A2 is "No" THEN D2 is "No"

Is there a way I can create a formula that would help.
 
rod411 said:
I am having difficulty inputting the correct formula for the following project I need.

Here goes:

If A2 is "Yes" and B2 or C2 are "Yes" THEN D2 is "Yes"

AND If A2 is "Yes" and if B2 and C2 are "Yes" THEN D2 is "Yes"

AND if A2 is "No" THEN D2 is "No"

Is there a way I can create a formula that would help.
Click to expand...
Hi,
Try this in d2.

=IF(AND(A2="Yes",OR(B2="yes",C2="yes")),"Yes",IF(A2="No","No",""))
 
You must log in or register to reply here.
Back
Top