LATIHAN VLOOKUP&HLOOKUP(5)

SOAL

1.MENCARI JABATAN STRUKTURAL

=IF(C2="I","STAF",IF(C2="II","KASUBAG",IF(C2="III","KABAG","DIREKSI")))

2. MENCARI GAJI POKOK

=VLOOKUP(C3,$B$20:$E$23,2)

3. MENCARI TUNJANGAN ISTRI

=IF(D2="NIKAH",VLOOKUP(C2,$B$20:$E$23,4),0)

4. MENCARI TUNJANGAN ANAK

=IF(AND(D2="NIKAH",E2<=3),VLOOKUP(C2,$B$20:$E$23,3)*E2,IF(AND(D2="NIKAH",E2>3),VLOOKUP(C2,$B$20:$E$23,3)*4,0))

5.MENCARI TUNJANGAN STRUKTURAL

=HLOOKUP(F2,$H$19:$K$20,2)

6.MENCARI TUNJANGAN TRANSPORT

=HLOOKUP(F2,$H$23:$K$24,2)

7. MENCARI TOTAL GAJI

=SUM(G2:I2)