LKS 17

Departemen
=IF(LEFT(B5,2)="D1","DEP1",IF(LEFT(B5,2)="D2","DEP2",IF(LEFT(B5,2)="D3","DEP3")))

Bagian
=IF(LEFT(B5,2)="D1","PROCESSOR",IF(LEFT(B5,2)="D2","PACKING",IF(LEFT(B5,2)="D3","MARKETING")))

Tahun Masuk
=1900+VALUE(MID(B5,4,2))

Lama Kerja
=2011-F5

Gaji Pokok
=IF(LEFT(B5,2)="D1",9000000,IF(LEFT(B5,2)="D2",1200000,IF(LEFT(B5,2)="D3",1300000)))

Tunjangan jabatan
 =IF(G5<=9,SUM(H5)*15,IF(G5>10,SUM(H5)*20%))

Total Pendapatan
=H5+I5