ExcelBanter - excel function help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel function help (https://www.excelbanter.com/excel-worksheet-functions/57503-excel-function-help.html)

fabien

excel function help

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

Bob Phillips

excel function help

=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

All times are GMT +1. The time now is 12:13 PM.