excel function help

F

fabien

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
 
B

Bob Phillips

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

--

HTH

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