Multiple if statement

[kac1125]

Hello,

Need help with the following If statement:
For Cell B1 if A1 = False and A2 = False then B1 =Yes Also, if A1 = True and A2 = False B1 = No finally if A1=True and A2 = True B1 = Yes please help me combine these into one if statement.

Thank you in advance!

 

[Joe4]

If cells A1 and A2 can only contain True of False, one way is:

=IF(AND(A1<>"",A1=A2),"Yes","No")

 

[kac1125]

If cells A1 and A2 can only contain True of False, one way is:

=IF(AND(A1<>"",A1=A2),"Yes","No")

Thank you so much! One more criteria I forgot to add was A1 = False and A2 = True I want B1 = Yes. How can I incorprate that into the above formula?

 

[Joe4]

So, basically the only time it should be "No" is if A1 is True and A2 is False?
Then try:

=IF(AND(A1="True",A2="False"),"No","Yes")

Note that if your values are Boolean values instead of String values, you may need to use:

=IF(AND(A1=TRUE,A2=FALSE),"No","Yes")