[belajar-excel] Digest Number 4225

Milis Belajar Microsoft Excel Group

3 Messages

Digest #4225

1

Membuat referensi nota dari transaksi barang by "farud oke"

2a

Re: Bls: [belajar-excel] Tanya Rumus Fungsi IF by "ribowo ." ribowo25

3a

Re: Summary Quaterly sales [1 Attachment] by "nangagus"

Messages

1

Membuat referensi nota dari transaksi barang

Sun Jul 2, 2017 9:52 am (PDT) . Posted by:

"farud oke"

Assalamualaikum master excel sekalian..mohon bantuannya
Bagaimana caranya agar referensi nota bisa terisi sendiri berdasarkan
transaksi yg terjadi tiap bulannya.untuk lebih jelasnya file terlampir.
Atas bantuan para master sekalian saya sampaikan beribu-ribu terimakasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2a

Re: Bls: [belajar-excel] Tanya Rumus Fungsi IF

Mon Jul 3, 2017 3:09 am (PDT) . Posted by:

"ribowo ." ribowo25

Dear Pak Fahmi,Terimakasih untuk bantuannya, rumus berjalan dengan mulus.
 Bowo_Cilacap_Kebumen_Jakarta


On Saturday, July 1, 2017 12:45 PM, "Fahmi Syaifullah fahmisyaifullah20@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Wa'alaikumsalam wr.wbMinal 'aidin wal faidzin
Pak bowo,
coba fungsi kayak gini taruh dicell E3=IF(VLOOKUP(B5,$B$13:$D$15,MATCH(C5,$B$12:$D$12,0),0)<=D5,"sukses&quot;,"gagal")semoga sesuai dengan harapan.
Wassalamu'alaikum wr.wb
Terim kasihfahmi 
Dikirim dari Yahoo Mail di Android

  Assalamualaikum,
Minal Aidin Wal Faidzan
mohon dibantu pencerahannya untuk penghitungan sesuai case berikut (file terlampir)

=Jika Pulau Jawa/Kalimantan/Sumatera, Proyek Jalan/Gedung, Durasi kurang dari target maka sukses, jika lebih dari target maka gagal Terimakasih.
Bowo

#yiv0607889920 #yiv0607889920 -- #yiv0607889920ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0607889920 #yiv0607889920ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0607889920 #yiv0607889920ygrp-mkp #yiv0607889920hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0607889920 #yiv0607889920ygrp-mkp #yiv0607889920ads {margin-bottom:10px;}#yiv0607889920 #yiv0607889920ygrp-mkp .yiv0607889920ad {padding:0 0;}#yiv0607889920 #yiv0607889920ygrp-mkp .yiv0607889920ad p {margin:0;}#yiv0607889920 #yiv0607889920ygrp-mkp .yiv0607889920ad a {color:#0000ff;text-decoration:none;}#yiv0607889920 #yiv0607889920ygrp-sponsor #yiv0607889920ygrp-lc {font-family:Arial;}#yiv0607889920 #yiv0607889920ygrp-sponsor #yiv0607889920ygrp-lc #yiv0607889920hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0607889920 #yiv0607889920ygrp-sponsor #yiv0607889920ygrp-lc .yiv0607889920ad {margin-bottom:10px;padding:0 0;}#yiv0607889920 #yiv0607889920actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0607889920 #yiv0607889920activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0607889920 #yiv0607889920activity span {font-weight:700;}#yiv0607889920 #yiv0607889920activity span:first-child {text-transform:uppercase;}#yiv0607889920 #yiv0607889920activity span a {color:#5085b6;text-decoration:none;}#yiv0607889920 #yiv0607889920activity span span {color:#ff7900;}#yiv0607889920 #yiv0607889920activity span .yiv0607889920underline {text-decoration:underline;}#yiv0607889920 .yiv0607889920attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0607889920 .yiv0607889920attach div a {text-decoration:none;}#yiv0607889920 .yiv0607889920attach img {border:none;padding-right:5px;}#yiv0607889920 .yiv0607889920attach label {display:block;margin-bottom:5px;}#yiv0607889920 .yiv0607889920attach label a {text-decoration:none;}#yiv0607889920 blockquote {margin:0 0 0 4px;}#yiv0607889920 .yiv0607889920bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0607889920 .yiv0607889920bold a {text-decoration:none;}#yiv0607889920 dd.yiv0607889920last p a {font-family:Verdana;font-weight:700;}#yiv0607889920 dd.yiv0607889920last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0607889920 dd.yiv0607889920last p span.yiv0607889920yshortcuts {margin-right:0;}#yiv0607889920 div.yiv0607889920attach-table div div a {text-decoration:none;}#yiv0607889920 div.yiv0607889920attach-table {width:400px;}#yiv0607889920 div.yiv0607889920file-title a, #yiv0607889920 div.yiv0607889920file-title a:active, #yiv0607889920 div.yiv0607889920file-title a:hover, #yiv0607889920 div.yiv0607889920file-title a:visited {text-decoration:none;}#yiv0607889920 div.yiv0607889920photo-title a, #yiv0607889920 div.yiv0607889920photo-title a:active, #yiv0607889920 div.yiv0607889920photo-title a:hover, #yiv0607889920 div.yiv0607889920photo-title a:visited {text-decoration:none;}#yiv0607889920 div#yiv0607889920ygrp-mlmsg #yiv0607889920ygrp-msg p a span.yiv0607889920yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0607889920 .yiv0607889920green {color:#628c2a;}#yiv0607889920 .yiv0607889920MsoNormal {margin:0 0 0 0;}#yiv0607889920 o {font-size:0;}#yiv0607889920 #yiv0607889920photos div {float:left;width:72px;}#yiv0607889920 #yiv0607889920photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0607889920 #yiv0607889920photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0607889920 #yiv0607889920reco-category {font-size:77%;}#yiv0607889920 #yiv0607889920reco-desc {font-size:77%;}#yiv0607889920 .yiv0607889920replbq {margin:4px;}#yiv0607889920 #yiv0607889920ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0607889920 #yiv0607889920ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0607889920 #yiv0607889920ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0607889920 #yiv0607889920ygrp-mlmsg select, #yiv0607889920 input, #yiv0607889920 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0607889920 #yiv0607889920ygrp-mlmsg pre, #yiv0607889920 code {font:115% monospace;}#yiv0607889920 #yiv0607889920ygrp-mlmsg * {line-height:1.22em;}#yiv0607889920 #yiv0607889920ygrp-mlmsg #yiv0607889920logo {padding-bottom:10px;}#yiv0607889920 #yiv0607889920ygrp-msg p a {font-family:Verdana;}#yiv0607889920 #yiv0607889920ygrp-msg p#yiv0607889920attach-count span {color:#1E66AE;font-weight:700;}#yiv0607889920 #yiv0607889920ygrp-reco #yiv0607889920reco-head {color:#ff7900;font-weight:700;}#yiv0607889920 #yiv0607889920ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0607889920 #yiv0607889920ygrp-sponsor #yiv0607889920ov li a {font-size:130%;text-decoration:none;}#yiv0607889920 #yiv0607889920ygrp-sponsor #yiv0607889920ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0607889920 #yiv0607889920ygrp-sponsor #yiv0607889920ov ul {margin:0;padding:0 0 0 8px;}#yiv0607889920 #yiv0607889920ygrp-text {font-family:Georgia;}#yiv0607889920 #yiv0607889920ygrp-text p {margin:0 0 1em 0;}#yiv0607889920 #yiv0607889920ygrp-text tt {font-size:120%;}#yiv0607889920 #yiv0607889920ygrp-vital ul li:last-child {border-right:none !important;}#yiv0607889920

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3a

Re: Summary Quaterly sales [1 Attachment]

Mon Jul 3, 2017 5:13 pm (PDT) . Posted by:

"nangagus"

Dear Boby Chua

di B14 dapat menggunakan formula:
=SUMPRODUCT(($B5:$M5)*($B$4:$M$4=B$13))

tetapi lebih sederhana usulan rumus pak Hendrik:

=B5+F5+J5

copy ke kiri dan ke bawah

salam

Agus

On 6/27/17 3:45 PM, BOBY CHUA boby66_chua@yahoo.com [belajar-excel] wrote:
> Dear para Master,
>
> Ini saya mau mohon bantuan dari master2 semua
>
> Sebelunya saya ucapakan terima kasih bayak
>
> Salam Sejahtera,
> Kasuma
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use