IF(OR(K4=2,L4=2,P4=2,Q4=2,T4=2,U4=2,X4=2), "FAIL","PASS")

you could also define a range on those columns and make a better formula.....



"Nadine" wrote:

No they have changed the criteria.

If specific cells containt a 2

K4,L4,P4,Q4,T4,U4,X4


"CurlerBob" wrote:

Try this:

=IF(ISNA(MATCH(2,A4:AF4,0)),"fail","pass")