tugas vlookup
TRANSCRIPT
-
7/25/2019 tugas vlookup
1/3
GROSIR BUSANA MUSLIM
Nama Barang Kode Produk Berat (gram) Harga Normal
Gamis GM01 350 165,000
Jilbab GM02 300 60,000
Mukena GM03 650 150,000
Koko GM04 250 90,000
Sarung GM05 500 55,000
Peci GM06 200 50,000
Sajaa! GM0" 150 #0,000
$asbi! GM0# 100 100,000
Nama Barang Kode Produk Berat (gram) Harga Normal
Sajaa! GM0" 150 #0,000
Nama Barang Harga Normal Unit Total
$asbi! 100000 50 5,000,000
LOOKUP !AN !ATA ALI!ATION
Nama Barang Harga Normal Unit Total
Koko 90000 15 1350000
LOOKUP !"NGAN NAMA RANG"
Nama Barang Harga Normal Unit Total
Gamis 165000 25 4125000
LOOKUP !AN #ORMULA
Nama Barang Unit Total
Koko 5 450000
LOOKUP !AN IN#"RROR
Nama Barang Harga Normal Unit Total
mukena 150000
-
7/25/2019 tugas vlookup
2/3
%& G&' %(M( P)G(*(+
G(J+
G(J+ P&K&K $%J(%G(% $-(%SP&-$
1 +. .eni 1,500,000 900,000 500,000
2 +/ (la 1,"50,000 1,000,000 600,000
3 +( (mana 1,250,000 #00,000 400,000
4 +. arano 1,500,000 900,000 500,0005 +/ +smano 1,"50,000 1,000,000 600,000
6 +( %urul 1,250,000 #00,000 400,000
" +. Sii 1,500,000 900,000 500,000
# + Sukamso 2,000,000 1,250,000 #00,000
$abel Gaji
Gol Ga$i Pokok Tun$angan Tran%&ort
+( 1,250,000 #00,000 400,000
+. 1,500,000 900,000 500,000
+/ 1,"50,000 1,000,000 600,000+ 2,000,000 1,250,000 #00,000
$abel Poongan Pajak
IA IB I' I!
2 3 4 5
-
7/25/2019 tugas vlookup
3/3
$&$(' G(J+ P(J(K G(J+ .)-S+
2,900,000 #",000 2,#13,000
3,350,000 134,000 3,216,000
2,450,000 49,000 2,401,000
2,900,000 #",000 2,#13,0003,350,000 134,000 3,216,000
2,450,000 49,000 2,401,000
2,900,000 #",000 2,#13,000
4,050,000 202,500 3,#4",500