Tugas kkpi Tkj [SMK PPI]

ket. pada gambar rumus exel diatas

-nilai MID
   Input manual
-nilai Final
   Input manual
 -nilai Paper
   Input manual

 -MID 3%
  =G6*D70
 -FINAL 50%
  =H6*E7
 -PAPER
  =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")))))

 


                                     SEKIAN DARI SAYA