Penyelesaian :
1. =VLOOKUP(LEFT(B6,3),tab,IF(MID(B6,4,1)="1",2,IF(MID(B6,4,1)="2",3,IF(MID(B6,4,1)="3",4,IF(MID(B6,4,1)="4",5,6)))))
2.
=VLOOKUP(LEFT(B6,2),$F$28:$G$31,2,0)
3.
=VLOOKUP(RIGHT(B6,1),$H$24:$I$26,2,0)
4.
=IF(G6<=3000,"Murah",IF(G6<=8000,"Sedang","Mahal"))
5.
=F6*G6
(untuk Nomor 5 jgn lupa format cellnya diganti menjadi Accounting, decimal place = 0 dan symbol = Rp. Indonesia)
Tidak ada komentar:
Posting Komentar