Selasa, 23 Februari 2016

[belajar-excel] Digest Number 3769

15 Messages

Digest #3769
1a
1d
Re: mencari nilai dpp dan ppn by "zainul_ulum[at]yahoo[dot]com" zainul_ulum

Messages

Tue Feb 23, 2016 3:14 am (PST) . Posted by:

"odong nando"

dear all,
sebetulnya sudah lama saya menghadapi kondisi menyulitkan ini, namun transaksi masih sedikit menjadi bukan masalah yang berarti, namun semakin berkembangnya perusahaan ternyata saya dapat mencari nilai dpp dan ppn sampai seharian. sudah jadi masalah sekarang... hehe...
mohon solusi untuk mencari nilai dpp dan ppn seperti terlampir br,

odong nando

Tue Feb 23, 2016 7:30 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Odong,

Dari contoh yg ada,untuk mencari nilai dpp dan ppn,hasil yg sesuai/diinginkan itu seperti apa..?

TerimaKasih.
Sent from Yahoo Mail on Android

Tue Feb 23, 2016 5:13 pm (PST) . Posted by:

"Winov X" winovx

diakalin aja lah
dpp1  pake round pembulatan 3dpp2  =round(dpp1;2)ppn   =round(0.1*dpp1;2)
total =  dpp2 + ppn hasilnya true semua
__Winarno__

Pada Selasa, 23 Februari 2016 18:14, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  dear all,
sebetulnya sudah lama saya menghadapi kondisi menyulitkan ini, namun transaksi masih sedikit menjadi bukan masalah yang berarti, namun semakin berkembangnya perusahaan ternyata saya dapat mencari nilai dpp dan ppn sampai seharian. sudah jadi masalah sekarang... hehe...
mohon solusi untuk mencari nilai dpp dan ppn seperti terlampir br,

odong nando
#yiv8692294262 #yiv8692294262 -- #yiv8692294262ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8692294262 #yiv8692294262ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8692294262 #yiv8692294262ygrp-mkp #yiv8692294262hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8692294262 #yiv8692294262ygrp-mkp #yiv8692294262ads {margin-bottom:10px;}#yiv8692294262 #yiv8692294262ygrp-mkp .yiv8692294262ad {padding:0 0;}#yiv8692294262 #yiv8692294262ygrp-mkp .yiv8692294262ad p {margin:0;}#yiv8692294262 #yiv8692294262ygrp-mkp .yiv8692294262ad a {color:#0000ff;text-decoration:none;}#yiv8692294262 #yiv8692294262ygrp-sponsor #yiv8692294262ygrp-lc {font-family:Arial;}#yiv8692294262 #yiv8692294262ygrp-sponsor #yiv8692294262ygrp-lc #yiv8692294262hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8692294262 #yiv8692294262ygrp-sponsor #yiv8692294262ygrp-lc .yiv8692294262ad {margin-bottom:10px;padding:0 0;}#yiv8692294262 #yiv8692294262actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8692294262 #yiv8692294262activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8692294262 #yiv8692294262activity span {font-weight:700;}#yiv8692294262 #yiv8692294262activity span:first-child {text-transform:uppercase;}#yiv8692294262 #yiv8692294262activity span a {color:#5085b6;text-decoration:none;}#yiv8692294262 #yiv8692294262activity span span {color:#ff7900;}#yiv8692294262 #yiv8692294262activity span .yiv8692294262underline {text-decoration:underline;}#yiv8692294262 .yiv8692294262attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8692294262 .yiv8692294262attach div a {text-decoration:none;}#yiv8692294262 .yiv8692294262attach img {border:none;padding-right:5px;}#yiv8692294262 .yiv8692294262attach label {display:block;margin-bottom:5px;}#yiv8692294262 .yiv8692294262attach label a {text-decoration:none;}#yiv8692294262 blockquote {margin:0 0 0 4px;}#yiv8692294262 .yiv8692294262bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8692294262 .yiv8692294262bold a {text-decoration:none;}#yiv8692294262 dd.yiv8692294262last p a {font-family:Verdana;font-weight:700;}#yiv8692294262 dd.yiv8692294262last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8692294262 dd.yiv8692294262last p span.yiv8692294262yshortcuts {margin-right:0;}#yiv8692294262 div.yiv8692294262attach-table div div a {text-decoration:none;}#yiv8692294262 div.yiv8692294262attach-table {width:400px;}#yiv8692294262 div.yiv8692294262file-title a, #yiv8692294262 div.yiv8692294262file-title a:active, #yiv8692294262 div.yiv8692294262file-title a:hover, #yiv8692294262 div.yiv8692294262file-title a:visited {text-decoration:none;}#yiv8692294262 div.yiv8692294262photo-title a, #yiv8692294262 div.yiv8692294262photo-title a:active, #yiv8692294262 div.yiv8692294262photo-title a:hover, #yiv8692294262 div.yiv8692294262photo-title a:visited {text-decoration:none;}#yiv8692294262 div#yiv8692294262ygrp-mlmsg #yiv8692294262ygrp-msg p a span.yiv8692294262yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8692294262 .yiv8692294262green {color:#628c2a;}#yiv8692294262 .yiv8692294262MsoNormal {margin:0 0 0 0;}#yiv8692294262 o {font-size:0;}#yiv8692294262 #yiv8692294262photos div {float:left;width:72px;}#yiv8692294262 #yiv8692294262photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8692294262 #yiv8692294262photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8692294262 #yiv8692294262reco-category {font-size:77%;}#yiv8692294262 #yiv8692294262reco-desc {font-size:77%;}#yiv8692294262 .yiv8692294262replbq {margin:4px;}#yiv8692294262 #yiv8692294262ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8692294262 #yiv8692294262ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8692294262 #yiv8692294262ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8692294262 #yiv8692294262ygrp-mlmsg select, #yiv8692294262 input, #yiv8692294262 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8692294262 #yiv8692294262ygrp-mlmsg pre, #yiv8692294262 code {font:115% monospace;}#yiv8692294262 #yiv8692294262ygrp-mlmsg * {line-height:1.22em;}#yiv8692294262 #yiv8692294262ygrp-mlmsg #yiv8692294262logo {padding-bottom:10px;}#yiv8692294262 #yiv8692294262ygrp-msg p a {font-family:Verdana;}#yiv8692294262 #yiv8692294262ygrp-msg p#yiv8692294262attach-count span {color:#1E66AE;font-weight:700;}#yiv8692294262 #yiv8692294262ygrp-reco #yiv8692294262reco-head {color:#ff7900;font-weight:700;}#yiv8692294262 #yiv8692294262ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8692294262 #yiv8692294262ygrp-sponsor #yiv8692294262ov li a {font-size:130%;text-decoration:none;}#yiv8692294262 #yiv8692294262ygrp-sponsor #yiv8692294262ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8692294262 #yiv8692294262ygrp-sponsor #yiv8692294262ov ul {margin:0;padding:0 0 0 8px;}#yiv8692294262 #yiv8692294262ygrp-text {font-family:Georgia;}#yiv8692294262 #yiv8692294262ygrp-text p {margin:0 0 1em 0;}#yiv8692294262 #yiv8692294262ygrp-text tt {font-size:120%;}#yiv8692294262 #yiv8692294262ygrp-vital ul li:last-child {border-right:none !important;}#yiv8692294262

Tue Feb 23, 2016 5:54 pm (PST) . Posted by:

"zainul_ulum[at]yahoo[dot]com" zainul_ulum

maaf ikut nimbrung.

bukankah perhitungan PPN menurut SE-22/PJ.24/1990 dibulatkan ke bawah hingga rupiah penuh?

sehingga rumus PPN nya menjadi sehingga fungsi excel yang cocok bukan ROUND tetapi TRUNC()

ppn =trunc(0.1*dpp1)

mohon koreksinya jika salah

-zainul

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, February 24, 2016 8:14 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] mencari nilai dpp dan ppn

diakalin aja lah

dpp1 pake round pembulatan 3

dpp2 =round(dpp1;2)

ppn =round(0.1*dpp1;2)

total = dpp2 + ppn

hasilnya true semua

__Winarno__

Pada Selasa, 23 Februari 2016 18:14, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

dear all,

sebetulnya sudah lama saya menghadapi kondisi menyulitkan ini, namun transaksi masih sedikit menjadi bukan masalah yang berarti, namun semakin berkembangnya perusahaan ternyata saya dapat mencari nilai dpp dan ppn sampai seharian. sudah jadi masalah sekarang... hehe...

mohon solusi untuk mencari nilai dpp dan ppn seperti terlampir

br,

odong nando

Tue Feb 23, 2016 6:53 pm (PST) . Posted by:

"odong nando"

mas tobi, mungkin lampiran berikut akan lebih jelas.
mas winarno, wah senang banget rasanya bisa nemuin formulanya, namun setelah saya coba ke inv tagihan ternyata masih ada yang nilai yang false, seperti terlampir.
mas zainul, betul mas, namun yang saya maksud adalah inv valas, jadi harus di pecah dulu nilai yang ditagihkan menjadi dpp dan ppn, yang wajar adalah nilai 2 angka di belakang koma, setelah itu hasilnya baru di kalikan dengan KMK sesuai tgl inv. barulah di bulatkan hingga rupiah penuh nilai ppn nya. br,

odong nando


Pada Rabu, 24 Februari 2016 8:54, "'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  maaf ikut nimbrung.bukankah perhitungan PPN menurut SE-22/PJ.24/1990 dibulatkan ke bawah hingga rupiah penuh?sehingga rumus PPN nya menjadi sehingga fungsi excel yang cocok bukan ROUND tetapi TRUNC()  ppn   =trunc(0.1*dpp1)  mohon koreksinya jika salah-zainul  From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, February 24, 2016 8:14 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] mencari nilai dpp dan ppn    diakalin aja lah  dpp1  pake round pembulatan 3dpp2  =round(dpp1;2)ppn   =round(0.1*dpp1;2)  total =  dpp2 + ppn hasilnya true semua
__Winarno__  Pada Selasa, 23 Februari 2016 18:14, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:    dear all,  sebetulnya sudah lama saya menghadapi kondisi menyulitkan ini, namun transaksi masih sedikit menjadi bukan masalah yang berarti, namun semakin berkembangnya perusahaan ternyata saya dapat mencari nilai dpp dan ppn sampai seharian. sudah jadi masalah sekarang... hehe...  mohon solusi untuk mencari nilai dpp dan ppn seperti terlampir br,

odong nando   #yiv7189910196 #yiv7189910196 -- #yiv7189910196ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7189910196 #yiv7189910196ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7189910196 #yiv7189910196ygrp-mkp #yiv7189910196hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7189910196 #yiv7189910196ygrp-mkp #yiv7189910196ads {margin-bottom:10px;}#yiv7189910196 #yiv7189910196ygrp-mkp .yiv7189910196ad {padding:0 0;}#yiv7189910196 #yiv7189910196ygrp-mkp .yiv7189910196ad p {margin:0;}#yiv7189910196 #yiv7189910196ygrp-mkp .yiv7189910196ad a {color:#0000ff;text-decoration:none;}#yiv7189910196 #yiv7189910196ygrp-sponsor #yiv7189910196ygrp-lc {font-family:Arial;}#yiv7189910196 #yiv7189910196ygrp-sponsor #yiv7189910196ygrp-lc #yiv7189910196hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7189910196 #yiv7189910196ygrp-sponsor #yiv7189910196ygrp-lc .yiv7189910196ad {margin-bottom:10px;padding:0 0;}#yiv7189910196 #yiv7189910196actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7189910196 #yiv7189910196activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7189910196 #yiv7189910196activity span {font-weight:700;}#yiv7189910196 #yiv7189910196activity span:first-child {text-transform:uppercase;}#yiv7189910196 #yiv7189910196activity span a {color:#5085b6;text-decoration:none;}#yiv7189910196 #yiv7189910196activity span span {color:#ff7900;}#yiv7189910196 #yiv7189910196activity span .yiv7189910196underline {text-decoration:underline;}#yiv7189910196 .yiv7189910196attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7189910196 .yiv7189910196attach div a {text-decoration:none;}#yiv7189910196 .yiv7189910196attach img {border:none;padding-right:5px;}#yiv7189910196 .yiv7189910196attach label {display:block;margin-bottom:5px;}#yiv7189910196 .yiv7189910196attach label a {text-decoration:none;}#yiv7189910196 blockquote {margin:0 0 0 4px;}#yiv7189910196 .yiv7189910196bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7189910196 .yiv7189910196bold a {text-decoration:none;}#yiv7189910196 dd.yiv7189910196last p a {font-family:Verdana;font-weight:700;}#yiv7189910196 dd.yiv7189910196last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7189910196 dd.yiv7189910196last p span.yiv7189910196yshortcuts {margin-right:0;}#yiv7189910196 div.yiv7189910196attach-table div div a {text-decoration:none;}#yiv7189910196 div.yiv7189910196attach-table {width:400px;}#yiv7189910196 div.yiv7189910196file-title a, #yiv7189910196 div.yiv7189910196file-title a:active, #yiv7189910196 div.yiv7189910196file-title a:hover, #yiv7189910196 div.yiv7189910196file-title a:visited {text-decoration:none;}#yiv7189910196 div.yiv7189910196photo-title a, #yiv7189910196 div.yiv7189910196photo-title a:active, #yiv7189910196 div.yiv7189910196photo-title a:hover, #yiv7189910196 div.yiv7189910196photo-title a:visited {text-decoration:none;}#yiv7189910196 div#yiv7189910196ygrp-mlmsg #yiv7189910196ygrp-msg p a span.yiv7189910196yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7189910196 .yiv7189910196green {color:#628c2a;}#yiv7189910196 .yiv7189910196MsoNormal {margin:0 0 0 0;}#yiv7189910196 o {font-size:0;}#yiv7189910196 #yiv7189910196photos div {float:left;width:72px;}#yiv7189910196 #yiv7189910196photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7189910196 #yiv7189910196photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7189910196 #yiv7189910196reco-category {font-size:77%;}#yiv7189910196 #yiv7189910196reco-desc {font-size:77%;}#yiv7189910196 .yiv7189910196replbq {margin:4px;}#yiv7189910196 #yiv7189910196ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7189910196 #yiv7189910196ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7189910196 #yiv7189910196ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7189910196 #yiv7189910196ygrp-mlmsg select, #yiv7189910196 input, #yiv7189910196 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7189910196 #yiv7189910196ygrp-mlmsg pre, #yiv7189910196 code {font:115% monospace;}#yiv7189910196 #yiv7189910196ygrp-mlmsg * {line-height:1.22em;}#yiv7189910196 #yiv7189910196ygrp-mlmsg #yiv7189910196logo {padding-bottom:10px;}#yiv7189910196 #yiv7189910196ygrp-msg p a {font-family:Verdana;}#yiv7189910196 #yiv7189910196ygrp-msg p#yiv7189910196attach-count span {color:#1E66AE;font-weight:700;}#yiv7189910196 #yiv7189910196ygrp-reco #yiv7189910196reco-head {color:#ff7900;font-weight:700;}#yiv7189910196 #yiv7189910196ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7189910196 #yiv7189910196ygrp-sponsor #yiv7189910196ov li a {font-size:130%;text-decoration:none;}#yiv7189910196 #yiv7189910196ygrp-sponsor #yiv7189910196ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7189910196 #yiv7189910196ygrp-sponsor #yiv7189910196ov ul {margin:0;padding:0 0 0 8px;}#yiv7189910196 #yiv7189910196ygrp-text {font-family:Georgia;}#yiv7189910196 #yiv7189910196ygrp-text p {margin:0 0 1em 0;}#yiv7189910196 #yiv7189910196ygrp-text tt {font-size:120%;}#yiv7189910196 #yiv7189910196ygrp-vital ul li:last-child {border-right:none !important;}#yiv7189910196

Tue Feb 23, 2016 10:32 pm (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Odong,

Mungkin seperti ini...

TerimaKasih,

Pada Rab, 24/2/16, odong nando odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] mencari nilai dpp dan ppn [1 Attachment]
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Rabu, 24 Februari, 2016, 9:53 AM


 









mas tobi,
mungkin lampiran berikut akan lebih jelas.
mas
winarno, wah senang banget rasanya bisa nemuin formulanya,
namun setelah saya coba ke inv tagihan ternyata masih ada
yang nilai yang false, seperti terlampir.
mas
zainul, betul mas, namun yang saya maksud adalah inv valas,
jadi harus di pecah dulu nilai yang ditagihkan menjadi dpp
dan ppn, yang wajar adalah nilai 2 angka di belakang koma,
setelah itu hasilnya baru di kalikan dengan KMK sesuai tgl
inv. barulah di bulatkan hingga rupiah penuh nilai ppn
nya. br,

odong
nando


Pada Rabu, 24
Februari 2016 8:54,
"'zainul_ulum[at]yahoo[dot]com'
zainul_ulum@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com> menulis:



 









maaf ikut
nimbrung.bukankah perhitungan PPN menurut
SE-22/PJ.24/1990 dibulatkan ke bawah hingga rupiah
penuh?sehingga rumus PPN nya menjadi
sehingga fungsi excel yang cocok bukan ROUND tetapi
TRUNC()  ppn  
=trunc(0.1*dpp1)  mohon koreksinya jika
salah-zainul  From: belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, February 24, 2016 8:14
AM
To:
belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] mencari
nilai dpp dan ppn    diakalin aja
lah
 dpp1  pake round pembulatan
3dpp2
 =round(dpp1;2)ppn
  =round(0.1*dpp1;2)
 total =  dpp2 +
ppn hasilnya true
semua
__Winarno__
 Pada Selasa, 23 Februari 2016
18:14, "odong nando odongnando@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:
   dear
all,
 sebetulnya sudah lama saya menghadapi
kondisi menyulitkan ini, namun transaksi masih sedikit
menjadi bukan masalah yang berarti, namun semakin
berkembangnya perusahaan ternyata saya dapat mencari nilai
dpp dan ppn sampai seharian. sudah jadi masalah sekarang...
hehe...
 mohon
solusi untuk mencari nilai dpp dan ppn seperti
terlampir br,

odong
nando
 






















#yiv9997182649 #yiv9997182649 --
#yiv9997182649ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv9997182649 #yiv9997182649ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9997182649 #yiv9997182649ygrp-mkp #yiv9997182649hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9997182649 #yiv9997182649ygrp-mkp #yiv9997182649ads {
margin-bottom:10px;}

#yiv9997182649 #yiv9997182649ygrp-mkp .yiv9997182649ad {
padding:0 0;}

#yiv9997182649 #yiv9997182649ygrp-mkp .yiv9997182649ad p {
margin:0;}

#yiv9997182649 #yiv9997182649ygrp-mkp .yiv9997182649ad a {
color:#0000ff;text-decoration:none;}
#yiv9997182649 #yiv9997182649ygrp-sponsor
#yiv9997182649ygrp-lc {
font-family:Arial;}

#yiv9997182649 #yiv9997182649ygrp-sponsor
#yiv9997182649ygrp-lc #yiv9997182649hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9997182649 #yiv9997182649ygrp-sponsor
#yiv9997182649ygrp-lc .yiv9997182649ad {
margin-bottom:10px;padding:0 0;}

#yiv9997182649 #yiv9997182649actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv9997182649 #yiv9997182649activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv9997182649 #yiv9997182649activity span {
font-weight:700;}

#yiv9997182649 #yiv9997182649activity span:first-child {
text-transform:uppercase;}

#yiv9997182649 #yiv9997182649activity span a {
color:#5085b6;text-decoration:none;}

#yiv9997182649 #yiv9997182649activity span span {
color:#ff7900;}

#yiv9997182649 #yiv9997182649activity span
.yiv9997182649underline {
text-decoration:underline;}

#yiv9997182649 .yiv9997182649attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv9997182649 .yiv9997182649attach div a {
text-decoration:none;}

#yiv9997182649 .yiv9997182649attach img {
border:none;padding-right:5px;}

#yiv9997182649 .yiv9997182649attach label {
display:block;margin-bottom:5px;}

#yiv9997182649 .yiv9997182649attach label a {
text-decoration:none;}

#yiv9997182649 blockquote {
margin:0 0 0 4px;}

#yiv9997182649 .yiv9997182649bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9997182649 .yiv9997182649bold a {
text-decoration:none;}

#yiv9997182649 dd.yiv9997182649last p a {
font-family:Verdana;font-weight:700;}

#yiv9997182649 dd.yiv9997182649last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv9997182649 dd.yiv9997182649last p
span.yiv9997182649yshortcuts {
margin-right:0;}

#yiv9997182649 div.yiv9997182649attach-table div div a {
text-decoration:none;}

#yiv9997182649 div.yiv9997182649attach-table {
width:400px;}

#yiv9997182649 div.yiv9997182649file-title a, #yiv9997182649
div.yiv9997182649file-title a:active, #yiv9997182649
div.yiv9997182649file-title a:hover, #yiv9997182649
div.yiv9997182649file-title a:visited {
text-decoration:none;}

#yiv9997182649 div.yiv9997182649photo-title a,
#yiv9997182649 div.yiv9997182649photo-title a:active,
#yiv9997182649 div.yiv9997182649photo-title a:hover,
#yiv9997182649 div.yiv9997182649photo-title a:visited {
text-decoration:none;}

#yiv9997182649 div#yiv9997182649ygrp-mlmsg
#yiv9997182649ygrp-msg p a span.yiv9997182649yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9997182649 .yiv9997182649green {
color:#628c2a;}

#yiv9997182649 .yiv9997182649MsoNormal {
margin:0 0 0 0;}

#yiv9997182649 o {
font-size:0;}

#yiv9997182649 #yiv9997182649photos div {
float:left;width:72px;}

#yiv9997182649 #yiv9997182649photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv9997182649 #yiv9997182649photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv9997182649 #yiv9997182649reco-category {
font-size:77%;}

#yiv9997182649 #yiv9997182649reco-desc {
font-size:77%;}

#yiv9997182649 .yiv9997182649replbq {
margin:4px;}

#yiv9997182649 #yiv9997182649ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv9997182649 #yiv9997182649ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv9997182649 #yiv9997182649ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv9997182649 #yiv9997182649ygrp-mlmsg select,
#yiv9997182649 input, #yiv9997182649 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv9997182649 #yiv9997182649ygrp-mlmsg pre, #yiv9997182649
code {
font:115% monospace;}

#yiv9997182649 #yiv9997182649ygrp-mlmsg * {
line-height:1.22em;}

#yiv9997182649 #yiv9997182649ygrp-mlmsg #yiv9997182649logo {
padding-bottom:10px;}


#yiv9997182649 #yiv9997182649ygrp-msg p a {
font-family:Verdana;}

#yiv9997182649 #yiv9997182649ygrp-msg
p#yiv9997182649attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9997182649 #yiv9997182649ygrp-reco
#yiv9997182649reco-head {
color:#ff7900;font-weight:700;}

#yiv9997182649 #yiv9997182649ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ov
li a {
font-size:130%;text-decoration:none;}

#yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9997182649 #yiv9997182649ygrp-text {
font-family:Georgia;}

#yiv9997182649 #yiv9997182649ygrp-text p {
margin:0 0 1em 0;}

#yiv9997182649 #yiv9997182649ygrp-text tt {
font-size:120%;}

#yiv9997182649 #yiv9997182649ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv9997182649

Tue Feb 23, 2016 3:40 am (PST) . Posted by:

"Agus Ramiyanto"

Dear Pakar Excel,

Assalaamu alaikum wr wb

Maaf lama tak muncul.

Kami menanyakan rumus yang lebih praktis untuk menghitung volume harian
menjadi mingguan seperti di contoh terlampir.

Karena kalo memakai rumus yang ada tidak bisa langsung copy paste rumusnya.

Atas segala pencerahannya dan bantuannya kami sampaikan terima kasih.

Wassalamu 'alaikum wr wb

Agus Ramiyanto

Tue Feb 23, 2016 4:44 am (PST) . Posted by:

"Adrie Handria" olang_ilang

Dh,

Bisa dicoba pake rumus ini ya pak
*=SUMIFS(C:C,B:B,">="&E4,B:B,"<="&F4)*

Semoga membantu
Salam,

Adrie

On 23/02/2016 18:28, 'Agus Ramiyanto' aramiyanto@gmail.com
[belajar-excel] wrote:
>
> Dear Pakar Excel,
>
> Assalaamu alaikum wr wb
>
> Maaf lama tak muncul.
>
> Kami menanyakan rumus yang lebih praktis untuk menghitung volume
> harian menjadi mingguan seperti di contoh terlampir.
>
> Karena kalo memakai rumus yang ada tidak bisa langsung copy paste
> rumusnya.
>
> Atas segala pencerahannya dan bantuannya kami sampaikan terima kasih.
>
> Wassalamu 'alaikum wr wb
>
> Agus Ramiyanto
>
>

Tue Feb 23, 2016 10:36 pm (PST) . Posted by:

"Agus Ramiyanto"

Dear Mr. Adrie,

Betul pak, sangat membantu.

Terima kasih.

Thanks & Regards,

Agus Ramiyanto

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 23 Februari 2016 18:59
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Rumus menghitung volume harian menjadi mingguan [1 Attachment]

Dh,

Bisa dicoba pake rumus ini ya pak
=SUMIFS(C:C,B:B,">="&E4,B:B,"<="&F4)

Semoga membantu
Salam,

Adrie

On 23/02/2016 18:28, 'Agus Ramiyanto' aramiyanto@gmail.com <mailto:aramiyanto@gmail.com> [belajar-excel] wrote:

Dear Pakar Excel,

Assalaamu alaikum wr wb

Maaf lama tak muncul.

Kami menanyakan rumus yang lebih praktis untuk menghitung volume harian menjadi mingguan seperti di contoh terlampir.

Karena kalo memakai rumus yang ada tidak bisa langsung copy paste rumusnya.

Atas segala pencerahannya dan bantuannya kami sampaikan terima kasih.

Wassalamu 'alaikum wr wb

Agus Ramiyanto

Tue Feb 23, 2016 4:40 am (PST) . Posted by:

"odong nando"

sepertinya bunga yang dibagikan dengan sisa bunga tidak matching br,

odong nando


Pada Selasa, 23 Februari 2016 16:17, "Ruswanto Anto rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Assalammualaikum, wr.wb
Selamat sore, teman-teman master excel, mohon bantuannya bagaimana mencari rumus untuk pembagian bunga SHU per anggota?berikut saya lampirkan datanya.Terimakasih atas bantuan dan perhatiannya.

Salam hormatRuswanto
#yiv5773407937 -- #yiv5773407937ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5773407937 #yiv5773407937ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5773407937 #yiv5773407937ygrp-mkp #yiv5773407937hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5773407937 #yiv5773407937ygrp-mkp #yiv5773407937ads {margin-bottom:10px;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad {padding:0 0;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad p {margin:0;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad a {color:#0000ff;text-decoration:none;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc {font-family:Arial;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc #yiv5773407937hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc .yiv5773407937ad {margin-bottom:10px;padding:0 0;}#yiv5773407937 #yiv5773407937actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5773407937 #yiv5773407937activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5773407937 #yiv5773407937activity span {font-weight:700;}#yiv5773407937 #yiv5773407937activity span:first-child {text-transform:uppercase;}#yiv5773407937 #yiv5773407937activity span a {color:#5085b6;text-decoration:none;}#yiv5773407937 #yiv5773407937activity span span {color:#ff7900;}#yiv5773407937 #yiv5773407937activity span .yiv5773407937underline {text-decoration:underline;}#yiv5773407937 .yiv5773407937attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5773407937 .yiv5773407937attach div a {text-decoration:none;}#yiv5773407937 .yiv5773407937attach img {border:none;padding-right:5px;}#yiv5773407937 .yiv5773407937attach label {display:block;margin-bottom:5px;}#yiv5773407937 .yiv5773407937attach label a {text-decoration:none;}#yiv5773407937 blockquote {margin:0 0 0 4px;}#yiv5773407937 .yiv5773407937bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5773407937 .yiv5773407937bold a {text-decoration:none;}#yiv5773407937 dd.yiv5773407937last p a {font-family:Verdana;font-weight:700;}#yiv5773407937 dd.yiv5773407937last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5773407937 dd.yiv5773407937last p span.yiv5773407937yshortcuts {margin-right:0;}#yiv5773407937 div.yiv5773407937attach-table div div a {text-decoration:none;}#yiv5773407937 div.yiv5773407937attach-table {width:400px;}#yiv5773407937 div.yiv5773407937file-title a, #yiv5773407937 div.yiv5773407937file-title a:active, #yiv5773407937 div.yiv5773407937file-title a:hover, #yiv5773407937 div.yiv5773407937file-title a:visited {text-decoration:none;}#yiv5773407937 div.yiv5773407937photo-title a, #yiv5773407937 div.yiv5773407937photo-title a:active, #yiv5773407937 div.yiv5773407937photo-title a:hover, #yiv5773407937 div.yiv5773407937photo-title a:visited {text-decoration:none;}#yiv5773407937 div#yiv5773407937ygrp-mlmsg #yiv5773407937ygrp-msg p a span.yiv5773407937yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5773407937 .yiv5773407937green {color:#628c2a;}#yiv5773407937 .yiv5773407937MsoNormal {margin:0 0 0 0;}#yiv5773407937 o {font-size:0;}#yiv5773407937 #yiv5773407937photos div {float:left;width:72px;}#yiv5773407937 #yiv5773407937photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5773407937 #yiv5773407937photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5773407937 #yiv5773407937reco-category {font-size:77%;}#yiv5773407937 #yiv5773407937reco-desc {font-size:77%;}#yiv5773407937 .yiv5773407937replbq {margin:4px;}#yiv5773407937 #yiv5773407937ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5773407937 #yiv5773407937ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5773407937 #yiv5773407937ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5773407937 #yiv5773407937ygrp-mlmsg select, #yiv5773407937 input, #yiv5773407937 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5773407937 #yiv5773407937ygrp-mlmsg pre, #yiv5773407937 code {font:115% monospace;}#yiv5773407937 #yiv5773407937ygrp-mlmsg * {line-height:1.22em;}#yiv5773407937 #yiv5773407937ygrp-mlmsg #yiv5773407937logo {padding-bottom:10px;}#yiv5773407937 #yiv5773407937ygrp-msg p a {font-family:Verdana;}#yiv5773407937 #yiv5773407937ygrp-msg p#yiv5773407937attach-count span {color:#1E66AE;font-weight:700;}#yiv5773407937 #yiv5773407937ygrp-reco #yiv5773407937reco-head {color:#ff7900;font-weight:700;}#yiv5773407937 #yiv5773407937ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov li a {font-size:130%;text-decoration:none;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov ul {margin:0;padding:0 0 0 8px;}#yiv5773407937 #yiv5773407937ygrp-text {font-family:Georgia;}#yiv5773407937 #yiv5773407937ygrp-text p {margin:0 0 1em 0;}#yiv5773407937 #yiv5773407937ygrp-text tt {font-size:120%;}#yiv5773407937 #yiv5773407937ygrp-vital ul li:last-child {border-right:none !important;}#yiv5773407937

Tue Feb 23, 2016 4:55 am (PST) . Posted by:

rwanto78

Betul om odong nando..sy bingung,..nanti sy kirim data aslinya..jumlah anggotanya memang sy kurangi..
Tks sebelumnya atas responnya
Powered by Telkomsel BlackBerry®

-----Original Message-----
From: "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Sender: belajar-excel@yahoogroups.com
Date: Tue, 23 Feb 2016 12:40:40
To: belajar-excel@yahoogroups.com<belajar-excel@yahoogroups.com>
Reply-To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Mencari jumlah pembagian bunga per anggota

sepertinya bunga yang dibagikan dengan sisa bunga tidak matching br,

odong nando


Pada Selasa, 23 Februari 2016 16:17, "Ruswanto Anto rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Assalammualaikum, wr.wb
Selamat sore, teman-teman master excel, mohon bantuannya bagaimana mencari rumus untuk pembagian bunga SHU per anggota?berikut saya lampirkan datanya.Terimakasih atas bantuan dan perhatiannya.

Salam hormatRuswanto
#yiv5773407937 -- #yiv5773407937ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5773407937 #yiv5773407937ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5773407937 #yiv5773407937ygrp-mkp #yiv5773407937hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5773407937 #yiv5773407937ygrp-mkp #yiv5773407937ads {margin-bottom:10px;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad {padding:0 0;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad p {margin:0;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad a {color:#0000ff;text-decoration:none;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc {font-family:Arial;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc #yiv5773407937hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc .yiv5773407937ad {margin-bottom:10px;padding:0 0;}#yiv5773407937 #yiv5773407937actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5773407937 #yiv5773407937activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5773407937 #yiv5773407937activity span {font-weight:700;}#yiv5773407937 #yiv5773407937activity span:first-child {text-transform:uppercase;}#yiv5773407937 #yiv5773407937activity span a {color:#5085b6;text-decoration:none;}#yiv5773407937 #yiv5773407937activity span span {color:#ff7900;}#yiv5773407937 #yiv5773407937activity span .yiv5773407937underline {text-decoration:underline;}#yiv5773407937 .yiv5773407937attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5773407937 .yiv5773407937attach div a {text-decoration:none;}#yiv5773407937 .yiv5773407937attach img {border:none;padding-right:5px;}#yiv5773407937 .yiv5773407937attach label {display:block;margin-bottom:5px;}#yiv5773407937 .yiv5773407937attach label a {text-decoration:none;}#yiv5773407937 blockquote {margin:0 0 0 4px;}#yiv5773407937 .yiv5773407937bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5773407937 .yiv5773407937bold a {text-decoration:none;}#yiv5773407937 dd.yiv5773407937last p a {font-family:Verdana;font-weight:700;}#yiv5773407937 dd.yiv5773407937last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5773407937 dd.yiv5773407937last p span.yiv5773407937yshortcuts {margin-right:0;}#yiv5773407937 div.yiv5773407937attach-table div div a {text-decoration:none;}#yiv5773407937 div.yiv5773407937attach-table {width:400px;}#yiv5773407937 div.yiv5773407937file-title a, #yiv5773407937 div.yiv5773407937file-title a:active, #yiv5773407937 div.yiv5773407937file-title a:hover, #yiv5773407937 div.yiv5773407937file-title a:visited {text-decoration:none;}#yiv5773407937 div.yiv5773407937photo-title a, #yiv5773407937 div.yiv5773407937photo-title a:active, #yiv5773407937 div.yiv5773407937photo-title a:hover, #yiv5773407937 div.yiv5773407937photo-title a:visited {text-decoration:none;}#yiv5773407937 div#yiv5773407937ygrp-mlmsg #yiv5773407937ygrp-msg p a span.yiv5773407937yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5773407937 .yiv5773407937green {color:#628c2a;}#yiv5773407937 .yiv5773407937MsoNormal {margin:0 0 0 0;}#yiv5773407937 o {font-size:0;}#yiv5773407937 #yiv5773407937photos div {float:left;width:72px;}#yiv5773407937 #yiv5773407937photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5773407937 #yiv5773407937photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5773407937 #yiv5773407937reco-category {font-size:77%;}#yiv5773407937 #yiv5773407937reco-desc {font-size:77%;}#yiv5773407937 .yiv5773407937replbq {margin:4px;}#yiv5773407937 #yiv5773407937ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5773407937 #yiv5773407937ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5773407937 #yiv5773407937ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5773407937 #yiv5773407937ygrp-mlmsg select, #yiv5773407937 input, #yiv5773407937 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5773407937 #yiv5773407937ygrp-mlmsg pre, #yiv5773407937 code {font:115% monospace;}#yiv5773407937 #yiv5773407937ygrp-mlmsg * {line-height:1.22em;}#yiv5773407937 #yiv5773407937ygrp-mlmsg #yiv5773407937logo {padding-bottom:10px;}#yiv5773407937 #yiv5773407937ygrp-msg p a {font-family:Verdana;}#yiv5773407937 #yiv5773407937ygrp-msg p#yiv5773407937attach-count span {color:#1E66AE;font-weight:700;}#yiv5773407937 #yiv5773407937ygrp-reco #yiv5773407937reco-head {color:#ff7900;font-weight:700;}#yiv5773407937 #yiv5773407937ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov li a {font-size:130%;text-decoration:none;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov ul {margin:0;padding:0 0 0 8px;}#yiv5773407937 #yiv5773407937ygrp-text {font-family:Georgia;}#yiv5773407937 #yiv5773407937ygrp-text p {margin:0 0 1em 0;}#yiv5773407937 #yiv5773407937ygrp-text tt {font-size:120%;}#yiv5773407937 #yiv5773407937ygrp-vital ul li:last-child {border-right:none !important;}#yiv5773407937


Tue Feb 23, 2016 10:36 pm (PST) . Posted by:

rwanto78

Selamat malam om odong nando...
Berikut data aslinya..sy dah coba, tp yg om bilang tidak matching..
Terimakasih atas bantuannya.
Ruswanto
Powered by Telkomsel BlackBerry®

-----Original Message-----
From: "rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Sender: belajar-excel@yahoogroups.com
Date: Tue, 23 Feb 2016 12:54:43
To: <belajar-excel@yahoogroups.com>
Reply-To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Mencari jumlah pembagian bunga per anggota

Betul om odong nando..sy bingung,..nanti sy kirim data aslinya..jumlah anggotanya memang sy kurangi..
Tks sebelumnya atas responnya
Powered by Telkomsel BlackBerry®

-----Original Message-----
From: "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Sender: belajar-excel@yahoogroups.com
Date: Tue, 23 Feb 2016 12:40:40
To: belajar-excel@yahoogroups.com<belajar-excel@yahoogroups.com>
Reply-To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Mencari jumlah pembagian bunga per anggota

sepertinya bunga yang dibagikan dengan sisa bunga tidak matching br,

odong nando


Pada Selasa, 23 Februari 2016 16:17, "Ruswanto Anto rwanto78@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Assalammualaikum, wr.wb
Selamat sore, teman-teman master excel, mohon bantuannya bagaimana mencari rumus untuk pembagian bunga SHU per anggota?berikut saya lampirkan datanya.Terimakasih atas bantuan dan perhatiannya.

Salam hormatRuswanto
#yiv5773407937 -- #yiv5773407937ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5773407937 #yiv5773407937ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5773407937 #yiv5773407937ygrp-mkp #yiv5773407937hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5773407937 #yiv5773407937ygrp-mkp #yiv5773407937ads {margin-bottom:10px;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad {padding:0 0;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad p {margin:0;}#yiv5773407937 #yiv5773407937ygrp-mkp .yiv5773407937ad a {color:#0000ff;text-decoration:none;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc {font-family:Arial;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc #yiv5773407937hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ygrp-lc .yiv5773407937ad {margin-bottom:10px;padding:0 0;}#yiv5773407937 #yiv5773407937actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5773407937 #yiv5773407937activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5773407937 #yiv5773407937activity span {font-weight:700;}#yiv5773407937 #yiv5773407937activity span:first-child {text-transform:uppercase;}#yiv5773407937 #yiv5773407937activity span a {color:#5085b6;text-decoration:none;}#yiv5773407937 #yiv5773407937activity span span {color:#ff7900;}#yiv5773407937 #yiv5773407937activity span .yiv5773407937underline {text-decoration:underline;}#yiv5773407937 .yiv5773407937attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5773407937 .yiv5773407937attach div a {text-decoration:none;}#yiv5773407937 .yiv5773407937attach img {border:none;padding-right:5px;}#yiv5773407937 .yiv5773407937attach label {display:block;margin-bottom:5px;}#yiv5773407937 .yiv5773407937attach label a {text-decoration:none;}#yiv5773407937 blockquote {margin:0 0 0 4px;}#yiv5773407937 .yiv5773407937bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5773407937 .yiv5773407937bold a {text-decoration:none;}#yiv5773407937 dd.yiv5773407937last p a {font-family:Verdana;font-weight:700;}#yiv5773407937 dd.yiv5773407937last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5773407937 dd.yiv5773407937last p span.yiv5773407937yshortcuts {margin-right:0;}#yiv5773407937 div.yiv5773407937attach-table div div a {text-decoration:none;}#yiv5773407937 div.yiv5773407937attach-table {width:400px;}#yiv5773407937 div.yiv5773407937file-title a, #yiv5773407937 div.yiv5773407937file-title a:active, #yiv5773407937 div.yiv5773407937file-title a:hover, #yiv5773407937 div.yiv5773407937file-title a:visited {text-decoration:none;}#yiv5773407937 div.yiv5773407937photo-title a, #yiv5773407937 div.yiv5773407937photo-title a:active, #yiv5773407937 div.yiv5773407937photo-title a:hover, #yiv5773407937 div.yiv5773407937photo-title a:visited {text-decoration:none;}#yiv5773407937 div#yiv5773407937ygrp-mlmsg #yiv5773407937ygrp-msg p a span.yiv5773407937yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5773407937 .yiv5773407937green {color:#628c2a;}#yiv5773407937 .yiv5773407937MsoNormal {margin:0 0 0 0;}#yiv5773407937 o {font-size:0;}#yiv5773407937 #yiv5773407937photos div {float:left;width:72px;}#yiv5773407937 #yiv5773407937photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5773407937 #yiv5773407937photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5773407937 #yiv5773407937reco-category {font-size:77%;}#yiv5773407937 #yiv5773407937reco-desc {font-size:77%;}#yiv5773407937 .yiv5773407937replbq {margin:4px;}#yiv5773407937 #yiv5773407937ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5773407937 #yiv5773407937ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5773407937 #yiv5773407937ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5773407937 #yiv5773407937ygrp-mlmsg select, #yiv5773407937 input, #yiv5773407937 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5773407937 #yiv5773407937ygrp-mlmsg pre, #yiv5773407937 code {font:115% monospace;}#yiv5773407937 #yiv5773407937ygrp-mlmsg * {line-height:1.22em;}#yiv5773407937 #yiv5773407937ygrp-mlmsg #yiv5773407937logo {padding-bottom:10px;}#yiv5773407937 #yiv5773407937ygrp-msg p a {font-family:Verdana;}#yiv5773407937 #yiv5773407937ygrp-msg p#yiv5773407937attach-count span {color:#1E66AE;font-weight:700;}#yiv5773407937 #yiv5773407937ygrp-reco #yiv5773407937reco-head {color:#ff7900;font-weight:700;}#yiv5773407937 #yiv5773407937ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov li a {font-size:130%;text-decoration:none;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5773407937 #yiv5773407937ygrp-sponsor #yiv5773407937ov ul {margin:0;padding:0 0 0 8px;}#yiv5773407937 #yiv5773407937ygrp-text {font-family:Georgia;}#yiv5773407937 #yiv5773407937ygrp-text p {margin:0 0 1em 0;}#yiv5773407937 #yiv5773407937ygrp-text tt {font-size:120%;}#yiv5773407937 #yiv5773407937ygrp-vital ul li:last-child {border-right:none !important;}#yiv5773407937


Tue Feb 23, 2016 10:14 pm (PST) . Posted by:

prasaja_satria

Selamat siang para master
mau tanya formula untuk mengambil huruf dari sebuah kata, mohon bantuannya
rentang hurufnya berbeda2, yang jelas cuma ada 1 huruf di sebuah data, nah saya ingin mengambil huruf tersebut saja
Untuk lebih jelas bisa diliat di attachment dimana ada sebuah "Data" dah kolom "Hasil" yang diinginkan

Terima kasih


Tue Feb 23, 2016 10:36 pm (PST) . Posted by:

pujo_winoko

Assalamualaikum,
saya pemula sedang belajar VBA dengan contoh-contoh yang ada di group ini dan search di google.saya latihan membuat 2 form, form login dan form biaya, dan sudah hampir selesai.

Akan tetapi ada masalah ketika di form login saya sisip kan :
" application.visible = False "
 dan hasilnya form excel saya tidak muncul, yang muncul hanya menu login dengan password : adminganteng
saya coba-coba masih tidak bisa dibuka. Mohon bantuan para master excel untuk masalah saya ini, agar saya bisa lanjutkan ke step berikutnya di form latihan saya tersebut.
berikut lampirannya, atas bantuannya saya ucapkan terima kasih.
Best Regards,

Pujo

Tue Feb 23, 2016 10:36 pm (PST) . Posted by:

dinsosnakertrans_09

Yth. Mas Hendrik Karnadi Terima kasih atas respon dan solusinya yang sangat memuaskan dan begitu cepat,
ibarat tanpa menunggu..., masalah sudah terpecahkan. Mudah-mudahan para Master Excel di Milis ini
tidak pernah bosan memberikan petunjuk dan pengajaran kepada pemula seperti saya ini, dan hanya Allah SWT
yang dapat membalas semua jerih payah para master di Milis ini.
sekali lagi terima kasih khususnya mas HK
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar