Nelly


=SUM(C3+D3)  total penduduk
=SUM(E3:E9) jumlah total distrik
=MAX(E3:E10)  jumlah penduduk tertingi
=MIN(E3:E10) total penduduk terendah
= AVERAGE(E3:E9) rata-rata penduduk
=COUNT(E3:E9) jumlah distrik

     foun
=IF(C4="DIR","DIREKTUR",IF(C4="SEK","SEKRETARIS",IF(C4="KAR","KARYAWAN")))   jabatan
=IF(C4="DIR",1500,IF(C4="SEK",1000,500))   gaji
=IF(F4=0,0,IF(F4=1,50,100))  bonus
=IF(E4="MENIKAH",150,50)  tunjangan
=IF(G4>=750,3%*G4,1%*G4)  kredit
=SUM(G4:I4)-J4  gaji bersih
=SUM(K4:K13) jumlah total gaji bersih
=MAX(K4:K13)  gaji bersih tertinggi
=MIN(K4:K13)  gaji bersih terendah
=COUNT(K4:K13)  jumlah pegawai
          foun

=VLOOKUP(C4,$B$22:$D$25,2,FALSE)  jabatan
=IF(C4="RD-D",1400,IF(C4="RD-M",900,IF(C4="RD-S",700,600))) gaji
=VLOOKUP(C4,$B$22:$D$25,3,FALSE)  bonus
=HLOOKUP(E4,$G$22:$H$23,2,FALSE) tunjanagan
=IF(G4<=650,2%*G4,IF(G4<=1000,2.5%*G4,3%*G4))  pajak
=G4+H4+I4-J4 gaji bersih
=IF(F4=0,"bulpen",IF(F4=1,"lemari es","komputer")) hadia
=SUM(K4:K13) jumlah total gaji bersih
=AVERAGE(K4:K13) gaji bersih rata-rata
=MAX(K4:K13) gaji bersih tertinggi
=MIN(K4:K13) gaji bersih terrendah
=COUNT(K4:K13) jumlah karyawan
           foun
=HLOOKUP(C5,$J$17:$N$19,2,FALSE) jabatan
=IF(C5="TL-D",1200,IF(C5="TL-M",900,IF(C5="TL-S",700,600)))  gaji
=HLOOKUP(C5,$J$17:$N$19,3,FALSE)  bonus
=VLOOKUP(E5,$N$9:$O$11,2,FALSE)  tungjangan
=IF(G5<=600,1.5%*G5,IF(G5<=1000,2%*G5,IF(G5>1000,2.5%*G5)))  pajak
=G5+H5+I5+-J5 gaji bersih
=IF(F5=0,"JAM TANGAN",IF(F5=1,"HP NOKIA","LAPTOP"))  hadia
=SUM(K5:K14) jumlah total gaji bersih
=AVERAGE(K5:K14)  gaji bersih rata-rata
=MAX(K5:K14) gaji bersih tertinggi
=MIN(K5:K14) gaji bersih terrendah
=COUNT(K5:K14) jumlah karyawan
          foun
=IF(C4="DIR","DIRETUR","KARYAWAN") keterangan
          foun
=AVERAGE(C4:F4) nilai rata-rata
=IF(G4>=59,"LULUS") keterangan
           foun
=IF(D5<=50,"tidah lulus",IF(D5<=69,"her ulang","lulus")) keterangan
=MAX(D5:D14) maximum
=MIN(D5:D14)  minimum
=AVERAGE(D5:D14) rata-rata
=COUNT(D5:D14) jumlah total
        foun

=LEFT(F5,2)  left
=MID(F5,3,3)  Mid
=RIGHT(F5,5)  right
=(F5) upper
=LOWER(F5) lower
=LEN(F5) len
     foun
=VLOOKUP(B4,B12:C16,2)  inkluim iha
      foun
=HLOOKUP(G4,G11:I12,2) inklui iha





Komentar