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.
Bookmarks