=IF(COUNTIF(A1:G1,"Y")0,"FAIL","PASS")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Clem" wrote in message
...
In following an audit program steps a condition may result as "OK", "N",
"NA", or "Y". I have a table with areas down the left and tests across
the
top:

A B C D H
Test1 Test2 Test3 etc. PASS/FAIL
1 Area1 OK OK Y FAIL
2 Area2 OK OK OK PASS
etc

I want the conditional function in the PASS/FAIL cells (H1, H2, etc) to
look
through the row to the left and return "FAIL" if there is any cell with
"Y"
in it, else "PASS".

How do I get the range as the criteria range, not just one cell? I can get
it to work if I say IF(A1="Y","FAIL","PASS"), but not
IF(A1:G1="Y","FAIL","PASS").
So, I need the test to iterate through a range for the given condition,
and
return the value I seek if ever it encounters the trigger criteria.