# Posts by 57Frog

Re: formula to compare a complete row to find &quot;yes&quot; &quot;no&quot; or blank

thank you I only needed to add the No
=IF(A1="YES","YES",IF(AND(A1="NO",B1="YES"),"YES",IF(AND(A1="NO",B1="NO"),"NO",IF(AND(A1="NO",B1=""),"NO","")))) Re: formula to compare a complete row to find &quot;yes&quot; &quot;no&quot; or blank

thank you almost except it is missing the No if both A&B are No
I can get it with =IF(A4="no",B4,A4-IF(B4="no",B4))

Re: formula to compare a complete row to find &quot;yes&quot; &quot;no&quot; or blank

I would like to paste a formula into C to give these values depending on what is in A or B
A B C
1 YES YES YES
2 YES NO YES
3 NO YES YES
4 NO NO NO
5 YES
6 NO
7

Re: formula to compare a complete row to find &quot;yes&quot; &quot;no&quot; or blank

sorry I misunderstood the question if
B1 is blank and A1= yes C1=Yes
B1 is blank and A1= no C1=no
my apologies

Re: formula to compare a complete row to find &quot;yes&quot; &quot;no&quot; or blank

Hi
thanks for the reply and welcome here
I am not concerned with B1 if A1 is blank B1 can be "yes" or "no" I only need C1 to be blank if A1 is blank

I've tried a few different things thinking I was on the right track based on the IF, and AND function.

I need to find if
cell A1 = "Yes" and B1 ="Yes" C1 = "Yes"
cell A1 = "Yes" and B1= "No" C1= "Yes"
cell A1= "No" and B1 ="Yes" C1= "Yes"
cell A1= "No" and B1 ="No" C1= "No"
cell A1= "Blank" C1 = "Blank"

I am not sure what formula to use for this
any help appreciated