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))