I have an audit spreadsheet listing rooms by the building its in, the room number and a series of answers to questions afterwards detaling if they passed a particular inspection point, or, if not, how many violations they had.
Bldg102 Rm 241 yes yes yes 3 yes yes NA 1 yes yes yes NA NA NA NA
I would like to put a note in the A column that tells me if the room had issues. I figure it would be something like If(a4 = "yes","",if(a4= "NA","","Fail")) but I want it to check every cell in the row and as long as there are only "yes" and "NA" responses, then it prints nothing. But if there is even one single OTHER answer value, then it prints "Fail". (if it helps, the answers section takes up K2:AA2, and I have 250 rooms to check results on, hence making excel do it for me).