Checking a row of cells and reporting

Closed
Martinwuff - Mar 16, 2009 at 10:32 AM
wonderpc Posts 15 Registration date Wednesday November 5, 2008 Status Member Last seen May 18, 2009 - Mar 17, 2009 at 05:05 AM
Hello,

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.

Example

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

Thanks so much!

1 response

wonderpc Posts 15 Registration date Wednesday November 5, 2008 Status Member Last seen May 18, 2009 2
Mar 17, 2009 at 05:05 AM
hi,
try this to see if it works for you:
If(a4:a<the last lettern in the row> = "yes","",if(a4:a<the last lettern in the row> = "NA","","Fail"))
1