Keterangan Rumus :
- Mid 30 %(=G6*D7)
- Final 50%
(=H6*E7)
- Paper 20%
(=I6*F7)
- Total nilai
(=SUM(G7:I7)*50%)
-Nilai huruf
(=IF(J7>=80;"A";IF(J7>=75;"B";IF(J7>=60;"C";IF(J7>=40;"D";IF(J7>=0;"E")))))
- Keterangan
(=IF(K7="A";"LULUS";IF(K7="B";"LULUS";IF(K7="C";"REMEDIAL"; IF(K7="D";"REMEDIAL";IF(K7="E";"GAGAL")))))
Tidak ada komentar:
Posting Komentar