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