=IF(COUNTIF(A1:E5,"U")0,"fail","pass")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fabien" wrote in message
...
suppose cells A1toE5=grades A,B,C,D,E or U in any combination and U=fail
how
do I print "pass" or "fail" thanks in anticipation