I have four cells three of them will either be Yes or NA and the fourth will contain the formula to check for these two values. I'm getting mixed results with this last iteration or formulas I've tried.

Criteria: All three cells Day, Evening, and Night need to be either "Yes" or "NA" to be "Yes" compliant but as you can see I'm getting mixed results in the table below.

=IF(AND(A2="Yes",OR(A2="NA",B2="Yes", B2="NA", C2="Yes", C2="NA")),"Yes","No")
Day Yes/NA Evening Yes/NA Night Yes/NA Compliant
Yes NA Yes Yes
NA Yes NA No
Yes NA Yes

Not sure how to get this figured out any help is appreciated, thanks.