yang terhormat, pak Agus hasilnya tetap saja menjadi 0 pak. saya juga heran kenapa? malah file lampiran yang bpk berikan kepada saya jikalau saya tekan F2 dia akan berubah menjadi 0 juga. saya ingin bertanya tentang rumus yang saya lampirkan pak, mohon maaf jika banyak bertanya soalnya blum begitu paham tentang rumus match dan indexnya. Terima kasih.fahmi
Pada Jumat, 28 November 2014 7:46, "'Bagus' [email protected]
[belajar-excel]" <[email protected]> menulis:
Mas Fahmi.. Xl saya juga versi 2007..Setelah file lampiran saya buka
memang hasilnya 0..coba select range F43:F73 lalu tekan tombol F2 dan Enter
maka akan muncul hasil spt yang diinginkan. Saya kurang tau kenapa koq harus
ditekan tombol F2 Enter..(kalo datanya banyak kan capek... J) Mungkin para
master ada yang tau kenapa koq bisa begitu..?? Wassalam ~ Bagus ~
----- Original Message ----- From: Fahmi Syaifullah
[email protected] [belajar-excel] To: [email protected]
Sent: Thursday, November 27, 2014 9:22 PM Subject: Bls: [belajar-excel] Rumus
gabungan Vlookup [1 Attachment]
yang terhormat, pak Agus
Setelah saya copas formula yang bpk kasih, knapa di excel saya jadi nilai 0
yaa? apa karna excel saya 2007 dan excel bapak 2010? (file saya lampirkan).
Mohon maaf sebelumnya.
Terima kasih, Fahmi
Pada Kamis, 27 November 2014 21:00, Fahmi Syaifullah
<[email protected]> menulis:
Yang terhormat, pak Agus
terima kasih atas bantuannya, sangat berguna pak.
wassalam.
Fahmi
Pada Selasa, 25 November 2014 19:47, "'Bagus' [email protected]
[belajar-excel]" <[email protected]> menulis:
Mas Fahmi; Sila lihat file terlampir.. Wassalam ~ Bagus ~
----- Original Message ----- From: Fahmi Syaifullah
[email protected] [belajar-excel] To: [email protected]
Sent: Tuesday, November 25, 2014 7:31 PM Subject: Bls: [belajar-excel] Rumus
gabungan Vlookup
yang terhormat pak bagus.
saya sudah coba formulanya, tapi kok hasinya nol yaa? mohon bantuannya .
wassalam fahmi syaifullah
Pada Selasa, 25 November 2014 13:13, "'Bagus' [email protected]
[belajar-excel]" <[email protected]> menulis:
Mas Fahmi; Coba begini:
=IFERROR(E43*INDEX($C$4:$G$15,MATCH(RIGHT(D43,6),$A$4:$A$15,0),MATCH(VLOOKUP(LEFT(D43,1),$I$6:$J$10,2,0),$C$3:$G$3,0)),0)
Copas kebawah Wassalam ~ Bagus ~
----- Original Message ----- From: Fahmi Syaifullah
[email protected] [belajar-excel] To: [email protected]
Sent: Monday, November 24, 2014 8:37 PM Subject: [belajar-excel] Rumus gabungan
Vlookup [1 Attachment]
Yang terhormat, Bapak / Ibu guru excel
berikut saya lampirkan suatu soal excel yang kiranya membutuhkan bantuan.
mohon bantuannya bapak / ibu. terimakasih, wassalam
regard, fahmi syaifullah
<!--#yiv7924970718 #yiv7924970718ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7924970718
#yiv7924970718ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7924970718
#yiv7924970718ygrp-mkp #yiv7924970718hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7924970718 #yiv7924970718ygrp-mkp #yiv7924970718ads
{margin-bottom:10px;}#yiv7924970718 #yiv7924970718ygrp-mkp .yiv7924970718ad
{padding:0 0;}#yiv7924970718 #yiv7924970718ygrp-mkp .yiv7924970718ad p
{margin:0;}#yiv7924970718 #yiv7924970718ygrp-mkp .yiv7924970718ad a
{color:#0000ff;text-decoration:none;}#yiv7924970718 #yiv7924970718ygrp-sponsor
#yiv7924970718ygrp-lc {font-family:Arial;}#yiv7924970718
#yiv7924970718ygrp-sponsor #yiv7924970718ygrp-lc #yiv7924970718hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7924970718
#yiv7924970718ygrp-sponsor #yiv7924970718ygrp-lc .yiv7924970718ad
{margin-bottom:10px;padding:0 0;}#yiv7924970718 #yiv7924970718actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7924970718
#yiv7924970718activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7924970718
#yiv7924970718activity span {font-weight:700;}#yiv7924970718
#yiv7924970718activity span:first-child
{text-transform:uppercase;}#yiv7924970718 #yiv7924970718activity span a
{color:#5085b6;text-decoration:none;}#yiv7924970718 #yiv7924970718activity span
span {color:#ff7900;}#yiv7924970718 #yiv7924970718activity span
.yiv7924970718underline {text-decoration:underline;}#yiv7924970718
.yiv7924970718attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7924970718 .yiv7924970718attach div a
{text-decoration:none;}#yiv7924970718 .yiv7924970718attach img
{border:none;padding-right:5px;}#yiv7924970718 .yiv7924970718attach label
{display:block;margin-bottom:5px;}#yiv7924970718 .yiv7924970718attach label a
{text-decoration:none;}#yiv7924970718 blockquote {margin:0 0 0
4px;}#yiv7924970718 .yiv7924970718bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7924970718
.yiv7924970718bold a {text-decoration:none;}#yiv7924970718 dd.yiv7924970718last
p a {font-family:Verdana;font-weight:700;}#yiv7924970718 dd.yiv7924970718last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7924970718
dd.yiv7924970718last p span.yiv7924970718yshortcuts
{margin-right:0;}#yiv7924970718 div.yiv7924970718attach-table div div a
{text-decoration:none;}#yiv7924970718 div.yiv7924970718attach-table
{width:400px;}#yiv7924970718 div.yiv7924970718file-title a, #yiv7924970718
div.yiv7924970718file-title a:active, #yiv7924970718
div.yiv7924970718file-title a:hover, #yiv7924970718 div.yiv7924970718file-title
a:visited {text-decoration:none;}#yiv7924970718 div.yiv7924970718photo-title a,
#yiv7924970718 div.yiv7924970718photo-title a:active, #yiv7924970718
div.yiv7924970718photo-title a:hover, #yiv7924970718
div.yiv7924970718photo-title a:visited {text-decoration:none;}#yiv7924970718
div#yiv7924970718ygrp-mlmsg #yiv7924970718ygrp-msg p a
span.yiv7924970718yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7924970718
.yiv7924970718green {color:#628c2a;}#yiv7924970718 .yiv7924970718MsoNormal
{margin:0 0 0 0;}#yiv7924970718 o {font-size:0;}#yiv7924970718
#yiv7924970718photos div {float:left;width:72px;}#yiv7924970718
#yiv7924970718photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7924970718
#yiv7924970718photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7924970718
#yiv7924970718reco-category {font-size:77%;}#yiv7924970718
#yiv7924970718reco-desc {font-size:77%;}#yiv7924970718 .yiv7924970718replbq
{margin:4px;}#yiv7924970718 #yiv7924970718ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7924970718 #yiv7924970718ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7924970718
#yiv7924970718ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7924970718
#yiv7924970718ygrp-mlmsg select, #yiv7924970718 input, #yiv7924970718 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7924970718
#yiv7924970718ygrp-mlmsg pre, #yiv7924970718 code {font:115%
monospace;}#yiv7924970718 #yiv7924970718ygrp-mlmsg *
{line-height:1.22em;}#yiv7924970718 #yiv7924970718ygrp-mlmsg #yiv7924970718logo
{padding-bottom:10px;}#yiv7924970718 #yiv7924970718ygrp-msg p a
{font-family:Verdana;}#yiv7924970718 #yiv7924970718ygrp-msg
p#yiv7924970718attach-count span {color:#1E66AE;font-weight:700;}#yiv7924970718
#yiv7924970718ygrp-reco #yiv7924970718reco-head
{color:#ff7900;font-weight:700;}#yiv7924970718 #yiv7924970718ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7924970718 #yiv7924970718ygrp-sponsor
#yiv7924970718ov li a {font-size:130%;text-decoration:none;}#yiv7924970718
#yiv7924970718ygrp-sponsor #yiv7924970718ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7924970718
#yiv7924970718ygrp-sponsor #yiv7924970718ov ul {margin:0;padding:0 0 0
8px;}#yiv7924970718 #yiv7924970718ygrp-text
{font-family:Georgia;}#yiv7924970718 #yiv7924970718ygrp-text p {margin:0 0 1em
0;}#yiv7924970718 #yiv7924970718ygrp-text tt {font-size:120%;}#yiv7924970718
#yiv7924970718ygrp-vital ul li:last-child {border-right:none !important;}-->
soal Latihan mandiri -7.xlsx
Description: MS-Excel 2007 spreadsheet
