Tugas PTI

Sabtu, 13 November 2010

3. Tugas PTI
1. Rencana Penelitian


2. 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