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!
Configuration: Windows XP Internet Explorer 7.0
Check in excel whether value is in a row Check per row on excel using vba Cmos checksum error - defaults loaded Color cell when checkbox clicked Computer says check media cable Copy cell in row if blank excel 2003 Delete non blank in the last non blank cell in a row Excel 2007 add offset to cell row Excel 2007 sum repeating cells Excel change the color of row according to cell value Excel macro if name found copy row Insert time to cell excel Macro delete row if cell does not contain Outlook outgoing server for cell phone email Schematic cell phone emergency battery Taringa descargar crystal reports for vb6.0 Vba check cell empty Vba check cell error