If/Or Formula Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a formula from a spreadsheet. I need the formula to
identify if column a and b are both yes OR if column c and d both equal yes
then the formula should equal true. A & B have to both = yes or C & D both
have to equal yes, so if A & B = Yes, Yes and C & D = Yes, No then that is a
true statement because I only need yes yes to appear once for a true value.

Thanks,
 
The following formula should do the trick:

=IF(OR(AND(A1="Yes",B1="Yes"),AND(C1="Yes",D1="Yes")),TRUE,FALSE)
 
Back
Top