Selasa, 01 Oktober 2013

Soal Excel LOOK UP dan Logika





Penyelesaian :
1. =VLOOKUP(MID(C6,6,2),harga,2,FALSE)
2. =VLOOKUP(MID(C6,6,2),harga,3,FALSE)
3. =VLOOKUP(LEFT(C6,4),jenis,2,FALSE)
4. =F6*H6
5. =VLOOKUP(LEFT(C6,4),jenis,3,FALSE)*I6
6. =I6-J6
7. =IF(E6="Komputer","Meja Komputer",IF(E6="Televisi","Rice Cooker",IF(E6="Kulkas","Meja Makan","Meja Belajar")))

Halaman