IF AND Statement

[JABJC01]

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

[Kevin UK]

Hi

How about

=IF(AND(A1<>"",COUNT(B1:F1)=0),"No","Yes")

[JABJC01]

Kevin,

Thank you. That's perfect!