Re: formula to compare a complete row to find "yes" "no" 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",""))))
Your help is most appreciated
Re: formula to compare a complete row to find "yes" "no" 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 "yes" "no" 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 "yes" "no" 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 "yes" "no" 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
