aplikom ib tugas chuy...

TUGAS APLIKOM IB DAFTAR NILAI MAHASISWA

1. Rumus Nilai Akhir : =SUM(C4*20%,D4*20%,E4*25%,F4*35%)


2. Rumus Grade : =IF(G4>=90,"A",IF(G4>=85,"B+",IF(G4>=80,"B",IF(G4>=75,"C+",IF(G4>=70,"C",IF(G4>=65,"D",IF(G4>=60,"E")))))))


3. Rumus Keterangan : =IF(H4="D","TIDAK LULUS",IF(H4="E","TIDAK LULUS","LULUS"))

4. Rumus Rata-rata : =AVERAGE(C4:F4)