Rumus Excel kompletu bele uza

  

DAFTAR GAJI PEGAWAI PT TIMOR DIAK

jabatan=IF(C7 ="td-01d","direktur",IF(C7="td-02m","manager",IF(C7="td-03s","sekretaris",IF(C7="td-04k","karyawan","sekurity"))))
status=IF(E7 ="bn","belum nikah",IF(E7="n","nikah"))
jlh anak =IF(D7="direktur",4,IF(D7="manager",3,IF(D7="sekretaris",0,IF(D7="karyawan",2,IF(D7="sekurity",1)))))
gaji pokok =IF(D7="direktur",1500,IF(D7="manager",1000,IF(D7="sekretaris",800,IF(D7="karyawan",500,300))))
Bonus =IF(D7="direktur",100,IF(D7="manager",75,IF(D7="sekretaris",50,IF(D7="karyawan",25,10))))
tunjangan =IF(D7="direktur",150,IF(D7="manager",100,IF(D7="sekretaris",0,IF(D7="karyawan",70,50))))
pajak 2% =2%*H7
gaji bersih =H7+I7+J7-K7
hadia natal =IF(D7="direktur",500,IF(D7="Manager",400,IF(D7="sekretaris",300,IF(D7="karyawan",200,IF(D7="sekurity",100)))))
bonus status nb,n =IF(F7="belum nikah",50,IF(F7="nikah",100))

JENIS KELAMIN =IF(C14="l","laki-laki",IF(C14="p","perempuan"))
POTONG PAJAK =J14-M14
JUMLAH PWGAWAI =COUNT(O14:O28)

RUMUS HLOOKUP
DAFTAR HARGA  PERANGKAT KOMPUTER DITOKO KAYA
NAMA BARAN =HLOOKUP(C6,$C$29:$H$31,2,FALSE)
HARGA/UNIT =HLOOKUP(C6,$C$29:$H$31,3,FALSE)
TOTAL HARGA =E6*F6
PAJAK 2% =2%*G6
HARGA BERSIH =G6-H6

KLIBUR MATADALAN
JABATAN =HLOOKUP(C13,$B$34:$F$36,2,FALSE)
GAJI =HLOOKUP(C13,$B$34:$F$36,3,FALSE)