Looking for a little help with my If Statement. I’m not getting the intended results. Here’s my formula:
=IF(AND(A1<>"",B1="",C1="",D1="",E1="",F1="",),"No","Yes")
Here’s what I’m trying to accomplish. If cell A1 is not blank and cells B1 thru F1 are blank; I want cell G1’s value to be No. If cell A1 is not blank and any of the cells B1 thru F1 are not blank either; then I want cell G1’s value to be Yes. My formula all returns a “yes” value.
Thank you