Dear Master DD,Sebelumnya di kolom Komposit Dus30/Pck15/Pcs, pertanyaan saya
bagaimana jika isi pada kolom komposit berisi Ball30/Pck15/Pcs,
Dus30/Rtg15/Pcs, Dus30/Cup dll. Mohon pencerahannya.
salam,Zulfikar
Pada Jumat, 29 Mei 2015 14:49, "Dede pmaho_l...@nabatisnack.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
DearMr Zul, Cobaformula ini di cell L8 :
=VLOOKUP(H8;$B$5:$E$13;4;)*I8+VLOOKUP(H8;$B$5:$E$13;4;)/IFERROR(MID(LEFT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;))-1);FIND("/Pck";VLOOKUP(H8;$B$5:$E$13;3;))+4;50);LEFT(RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;)));FIND("/Pcs";RIGHT(VLOOKUP(H8;$B$5:$E$13;3;);FIND("/Pcs";VLOOKUP(H8;$B$5:$E$13;3;))))-1))*J8+VLOOKUP(H8;$B$5:$E$13;4;)/VLOOKUP(H8;$B$5:$E$13;2;)*K8
Semogasesuai harapan. Salam, DD From: Zulfikar
nzulfikar_rout...@yahoo.com
[belajar-excel][mailto:belajar-excel@yahoogroups.com]
Sent: 29 Mei 2015 09:57
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Rumus Total Harga [1 Attachment] Dear Master,
Mohon bantuannya untuk kasus saya terlampir, rencananya saya akanmembuat tools
sederhana untuk melihat total harga barang jika saya input dikolom kuantiti
barang sesuai orderan pelanggan akan terakumulasi totalharganya. Untuk lebih
jelasnya bisa di lihat di file terlampir. Terima kasih, salam Zulfikar
Palopo, Sulsel This e-mail and any files transmitted with it are
confidential andintended solely for the use of the individual to whom it is
addressed. If youhave received this email in error please send it back to the
person that sentit to you. Any views or opinions presented are solely those of
its author anddo not necessarily represent those of NABATI or any of its
subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding,
printingor copying of this email and its associated attachments is strictly
prohibited. #yiv5178034296 #yiv5178034296 -- #yiv5178034296ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv5178034296 #yiv5178034296ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv5178034296 #yiv5178034296ygrp-mkp #yiv5178034296hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5178034296 #yiv5178034296ygrp-mkp #yiv5178034296ads
{margin-bottom:10px;}#yiv5178034296 #yiv5178034296ygrp-mkp .yiv5178034296ad
{padding:0 0;}#yiv5178034296 #yiv5178034296ygrp-mkp .yiv5178034296ad p
{margin:0;}#yiv5178034296 #yiv5178034296ygrp-mkp .yiv5178034296ad a
{color:#0000ff;text-decoration:none;}#yiv5178034296 #yiv5178034296ygrp-sponsor
#yiv5178034296ygrp-lc {font-family:Arial;}#yiv5178034296
#yiv5178034296ygrp-sponsor #yiv5178034296ygrp-lc #yiv5178034296hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5178034296
#yiv5178034296ygrp-sponsor #yiv5178034296ygrp-lc .yiv5178034296ad
{margin-bottom:10px;padding:0 0;}#yiv5178034296 #yiv5178034296actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5178034296
#yiv5178034296activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5178034296
#yiv5178034296activity span {font-weight:700;}#yiv5178034296
#yiv5178034296activity span:first-child
{text-transform:uppercase;}#yiv5178034296 #yiv5178034296activity span a
{color:#5085b6;text-decoration:none;}#yiv5178034296 #yiv5178034296activity span
span {color:#ff7900;}#yiv5178034296 #yiv5178034296activity span
.yiv5178034296underline {text-decoration:underline;}#yiv5178034296
.yiv5178034296attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5178034296 .yiv5178034296attach div a
{text-decoration:none;}#yiv5178034296 .yiv5178034296attach img
{border:none;padding-right:5px;}#yiv5178034296 .yiv5178034296attach label
{display:block;margin-bottom:5px;}#yiv5178034296 .yiv5178034296attach label a
{text-decoration:none;}#yiv5178034296 blockquote {margin:0 0 0
4px;}#yiv5178034296 .yiv5178034296bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5178034296
.yiv5178034296bold a {text-decoration:none;}#yiv5178034296 dd.yiv5178034296last
p a {font-family:Verdana;font-weight:700;}#yiv5178034296 dd.yiv5178034296last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5178034296
dd.yiv5178034296last p span.yiv5178034296yshortcuts
{margin-right:0;}#yiv5178034296 div.yiv5178034296attach-table div div a
{text-decoration:none;}#yiv5178034296 div.yiv5178034296attach-table
{width:400px;}#yiv5178034296 div.yiv5178034296file-title a, #yiv5178034296
div.yiv5178034296file-title a:active, #yiv5178034296
div.yiv5178034296file-title a:hover, #yiv5178034296 div.yiv5178034296file-title
a:visited {text-decoration:none;}#yiv5178034296 div.yiv5178034296photo-title a,
#yiv5178034296 div.yiv5178034296photo-title a:active, #yiv5178034296
div.yiv5178034296photo-title a:hover, #yiv5178034296
div.yiv5178034296photo-title a:visited {text-decoration:none;}#yiv5178034296
div#yiv5178034296ygrp-mlmsg #yiv5178034296ygrp-msg p a
span.yiv5178034296yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5178034296
.yiv5178034296green {color:#628c2a;}#yiv5178034296 .yiv5178034296MsoNormal
{margin:0 0 0 0;}#yiv5178034296 o {font-size:0;}#yiv5178034296
#yiv5178034296photos div {float:left;width:72px;}#yiv5178034296
#yiv5178034296photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5178034296
#yiv5178034296photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5178034296
#yiv5178034296reco-category {font-size:77%;}#yiv5178034296
#yiv5178034296reco-desc {font-size:77%;}#yiv5178034296 .yiv5178034296replbq
{margin:4px;}#yiv5178034296 #yiv5178034296ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5178034296 #yiv5178034296ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5178034296
#yiv5178034296ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5178034296
#yiv5178034296ygrp-mlmsg select, #yiv5178034296 input, #yiv5178034296 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5178034296
#yiv5178034296ygrp-mlmsg pre, #yiv5178034296 code {font:115%
monospace;}#yiv5178034296 #yiv5178034296ygrp-mlmsg *
{line-height:1.22em;}#yiv5178034296 #yiv5178034296ygrp-mlmsg #yiv5178034296logo
{padding-bottom:10px;}#yiv5178034296 #yiv5178034296ygrp-msg p a
{font-family:Verdana;}#yiv5178034296 #yiv5178034296ygrp-msg
p#yiv5178034296attach-count span {color:#1E66AE;font-weight:700;}#yiv5178034296
#yiv5178034296ygrp-reco #yiv5178034296reco-head
{color:#ff7900;font-weight:700;}#yiv5178034296 #yiv5178034296ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5178034296 #yiv5178034296ygrp-sponsor
#yiv5178034296ov li a {font-size:130%;text-decoration:none;}#yiv5178034296
#yiv5178034296ygrp-sponsor #yiv5178034296ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5178034296
#yiv5178034296ygrp-sponsor #yiv5178034296ov ul {margin:0;padding:0 0 0
8px;}#yiv5178034296 #yiv5178034296ygrp-text
{font-family:Georgia;}#yiv5178034296 #yiv5178034296ygrp-text p {margin:0 0 1em
0;}#yiv5178034296 #yiv5178034296ygrp-text tt {font-size:120%;}#yiv5178034296
#yiv5178034296ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5178034296
