If Then Statement

[melbrod]

Good morning! I am trying to create a rule that achieves the following:

If Column C says "Yes" and/or Column D says "Yes" then say "Yes" in column E.

This is what I was using but it is erroring out on me, and I am not sure what else I need to use. Thanks!

=IF(AND(C2="Yes",D2="Yes")),"Yes","No")

 

[njimack]

=IF(OR(C2="Yes",D2="Yes"),"Y","N")

 

[Joe4]

Welcome to the Board!

You were getting an error because your parentheses aren't balanced. You had two left ones "(" and three right ones ")".

And just to clarify:
- With AND, all conditions must be TRUE to return TRUE
- With OR, only one condition has to be TRUE to return TRUE

 

[melbrod]

Thank you!! Worked like a charm!

 

[melbrod]

I didn't even realize the lack of balance, thanks for that. I was editing formulas that I found online and I didn't catch that. Thank you again!