3. Tugas PTI
1. Rencana Penelitian2. Nilai Mahasiwa
Keterangan :
Total Nilai = ((0.4*D4)+(0.5*E4)+(0.1*C4))
Nilai Huruf =IF(F4>=80,"A",IF(AND(F4<=80,F4>=60),
"B",IF(AND(F4<=60,F4>=40),
"C",IF(AND(F4<40,F4>=20),"D","E"))))
Nilai Rata-Rata =AVERAGE(C4:C6)
Nilai Tertinggi =MAX(C4:C6)
Nilai Terendah =MIN(C4:C6)



0 komentar:
Posting Komentar