Checking a row of cells and reporting [Closed]

Report
-
Posts
15
Registration date
Wednesday November 5, 2008
Status
Member
Last seen
May 18, 2009
-
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 reply

Posts
15
Registration date
Wednesday November 5, 2008
Status
Member
Last seen
May 18, 2009
1
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!