Students' Grades

Excel 2016 file:   studentsgrades.xlsx

Formula		Cell
Pass / Fail
=IF(D2<65,"Fail","Pass") =IF(D3<65,"Fail","Pass") =IF(D4<65,"Fail","Pass") =IF(D5<65,"Fail","Pass") =IF(D6<65,"Fail","Pass") =IF(D7<65,"Fail","Pass") =IF(D8<65,"Fail","Pass") =IF(D9<65,"Fail","Pass") =IF(D10<65,"Fail","Pass") =IF(D11<65,"Fail","Pass") =IF(D12<65,"Fail","Pass") =IF(D13<65,"Fail","Pass") =IF(D14<65,"Fail","Pass") =IF(D15<65,"Fail","Pass") =IF(D16<65,"Fail","Pass") =IF(D17<65,"Fail","Pass") =IF(D18<65,"Fail","Pass") =IF(D19<65,"Fail","Pass")		E2 E3 E4 E5 E6 E7 E8 E9 E10 E11 E12 E13 E14 E15 E16 E17 E18 E19

---

=AVERAGE(D2:D19) =MAX(D2:D19) =MIN(D2:D19) =COUNTIF(E2:E19,"Pass") =COUNTIF(E2:E19,"Fail") =COUNT(D2:D19) 65

B21 B22 B23 B24 B25 B26 B27