Hi Nikki,

If your cells are adjacent:
=IF(SUMPRODUCT(--(A1:A20="PASS"))=COUNTA(A1:A20),"PASS","FAIL")
=IF(SUMPRODUCT(--(A1:A20="FAIL"))0,"FAIL","PASS")

If not, array-enter for example:
=IF(SUM(--(A1="FAIL"),--(A7="FAIL"),--(A9="FAIL"))0,"FAIL","PASS")

Regards,
Bernd