LATIHAN VLOOKUP & HLOOKUP (4)

SOAL

1. MENCARI LIMIT SEWA

=IF(C2=4,3,IF(C2=3,2,IF(C2=2,1,0)))

2. MENCARI MASA SEWA

=VALUE(LEFT(F2,2)-LEFT(E2,2))

3. MENCARI STATUS DENDA

=IF(G2>D2,"DENDA","TIDAK")

4. MENCARI BIAYA SEWA

=VLOOKUP(B2,$B$14:$E$17,3)*C2

5. MENCARI BIAYA DENDA

=IF(H2="DENDA",VLOOKUP(B2,$B$14:$E$17,4),0)*C2*(G2-D2)

6. MENCARI TOTAL BIAYA

=I2+J2