If/Or Formula Functions
 

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,

If/Or Formula Functions
 

The following formula should do the trick:

=IF(OR(AND(A1="Yes",B1="Yes"),AND(C1="Yes",D1="Yes ")),TRUE,FALSE)
--
Kevin Backmann


"Dawnvz32" wrote:

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,