coba masukan
=IFERROR(VLOOKUP(A10;$L$3:$M$4;2;0)*B10;B10)
pada cell D10, dan copas kebawah
note : jika regional setting kompi setempat english maka ubah titik koma ";"
menjadi koma "," br,
odong nando
Pada Kamis, 3 Maret 2016 9:25, "Susilo - [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Lukman
Coba ketik rumus berikut di sel
D10=IF(C10="KG",B10*1,B10*VLOOKUP(A10,$L$3:$M$4,2,0))
Lalu copy rumusnya ke bawahSemoga bisa membantu
Terima kasihSusilo
Pada 3 Maret 2016 07.30, [email protected] [belajar-excel]
<[email protected]> menulis:
Dear Mr. Odong Nando,
Thank's 4 ur respon,
kok itu sama-sama SHT tapi angka konfersinya berbeda...??? ( iya SHT
konversinya berbeda-beda)jadi apa kriterianya untuk mengambil data konfersi...?
(kriterianya adalah konversi-nya)klo diliat itu vlookupnya mengacu pada ID,
apakah akan di konfersi berdasarkan ID value...? Ya jadi ID 1000445 konversinya
0.123456 dan ID 1000791 konversinya 0.654321, selain ID tsb di konversinya di
kalikan 1.
Terimakasih,Br,
Lukman
#yiv8587411150 #yiv8587411150 -- #yiv8587411150ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8587411150
#yiv8587411150ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8587411150
#yiv8587411150ygrp-mkp #yiv8587411150hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8587411150 #yiv8587411150ygrp-mkp #yiv8587411150ads
{margin-bottom:10px;}#yiv8587411150 #yiv8587411150ygrp-mkp .yiv8587411150ad
{padding:0 0;}#yiv8587411150 #yiv8587411150ygrp-mkp .yiv8587411150ad p
{margin:0;}#yiv8587411150 #yiv8587411150ygrp-mkp .yiv8587411150ad a
{color:#0000ff;text-decoration:none;}#yiv8587411150 #yiv8587411150ygrp-sponsor
#yiv8587411150ygrp-lc {font-family:Arial;}#yiv8587411150
#yiv8587411150ygrp-sponsor #yiv8587411150ygrp-lc #yiv8587411150hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8587411150
#yiv8587411150ygrp-sponsor #yiv8587411150ygrp-lc .yiv8587411150ad
{margin-bottom:10px;padding:0 0;}#yiv8587411150 #yiv8587411150actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8587411150
#yiv8587411150activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8587411150
#yiv8587411150activity span {font-weight:700;}#yiv8587411150
#yiv8587411150activity span:first-child
{text-transform:uppercase;}#yiv8587411150 #yiv8587411150activity span a
{color:#5085b6;text-decoration:none;}#yiv8587411150 #yiv8587411150activity span
span {color:#ff7900;}#yiv8587411150 #yiv8587411150activity span
.yiv8587411150underline {text-decoration:underline;}#yiv8587411150
.yiv8587411150attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8587411150 .yiv8587411150attach div a
{text-decoration:none;}#yiv8587411150 .yiv8587411150attach img
{border:none;padding-right:5px;}#yiv8587411150 .yiv8587411150attach label
{display:block;margin-bottom:5px;}#yiv8587411150 .yiv8587411150attach label a
{text-decoration:none;}#yiv8587411150 blockquote {margin:0 0 0
4px;}#yiv8587411150 .yiv8587411150bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8587411150
.yiv8587411150bold a {text-decoration:none;}#yiv8587411150 dd.yiv8587411150last
p a {font-family:Verdana;font-weight:700;}#yiv8587411150 dd.yiv8587411150last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8587411150
dd.yiv8587411150last p span.yiv8587411150yshortcuts
{margin-right:0;}#yiv8587411150 div.yiv8587411150attach-table div div a
{text-decoration:none;}#yiv8587411150 div.yiv8587411150attach-table
{width:400px;}#yiv8587411150 div.yiv8587411150file-title a, #yiv8587411150
div.yiv8587411150file-title a:active, #yiv8587411150
div.yiv8587411150file-title a:hover, #yiv8587411150 div.yiv8587411150file-title
a:visited {text-decoration:none;}#yiv8587411150 div.yiv8587411150photo-title a,
#yiv8587411150 div.yiv8587411150photo-title a:active, #yiv8587411150
div.yiv8587411150photo-title a:hover, #yiv8587411150
div.yiv8587411150photo-title a:visited {text-decoration:none;}#yiv8587411150
div#yiv8587411150ygrp-mlmsg #yiv8587411150ygrp-msg p a
span.yiv8587411150yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8587411150
.yiv8587411150green {color:#628c2a;}#yiv8587411150 .yiv8587411150MsoNormal
{margin:0 0 0 0;}#yiv8587411150 o {font-size:0;}#yiv8587411150
#yiv8587411150photos div {float:left;width:72px;}#yiv8587411150
#yiv8587411150photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8587411150
#yiv8587411150photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8587411150
#yiv8587411150reco-category {font-size:77%;}#yiv8587411150
#yiv8587411150reco-desc {font-size:77%;}#yiv8587411150 .yiv8587411150replbq
{margin:4px;}#yiv8587411150 #yiv8587411150ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8587411150 #yiv8587411150ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8587411150
#yiv8587411150ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8587411150
#yiv8587411150ygrp-mlmsg select, #yiv8587411150 input, #yiv8587411150 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8587411150
#yiv8587411150ygrp-mlmsg pre, #yiv8587411150 code {font:115%
monospace;}#yiv8587411150 #yiv8587411150ygrp-mlmsg *
{line-height:1.22em;}#yiv8587411150 #yiv8587411150ygrp-mlmsg #yiv8587411150logo
{padding-bottom:10px;}#yiv8587411150 #yiv8587411150ygrp-msg p a
{font-family:Verdana;}#yiv8587411150 #yiv8587411150ygrp-msg
p#yiv8587411150attach-count span {color:#1E66AE;font-weight:700;}#yiv8587411150
#yiv8587411150ygrp-reco #yiv8587411150reco-head
{color:#ff7900;font-weight:700;}#yiv8587411150 #yiv8587411150ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8587411150 #yiv8587411150ygrp-sponsor
#yiv8587411150ov li a {font-size:130%;text-decoration:none;}#yiv8587411150
#yiv8587411150ygrp-sponsor #yiv8587411150ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8587411150
#yiv8587411150ygrp-sponsor #yiv8587411150ov ul {margin:0;padding:0 0 0
8px;}#yiv8587411150 #yiv8587411150ygrp-text
{font-family:Georgia;}#yiv8587411150 #yiv8587411150ygrp-text p {margin:0 0 1em
0;}#yiv8587411150 #yiv8587411150ygrp-text tt {font-size:120%;}#yiv8587411150
#yiv8587411150ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8587411150
