For than one way to skin this cat...but I would use the countif formula...

=IF(COUNTIF(A4:AF4,2)0,"FAIL","PASS")


"Nadine" wrote:

If any cell in a range of cells A4:AF4 contain the number 2, pass or fail
if a cell contains a 2 want result to show value of fail