Sama2 Ruswanto.Dalam penulisan/copy formula memang kita harus ber-hati2 krn
formula bersifat "struktural", namun kadang2 kita lupa menaruh tanda "$" (F4)
sebelum mengcopy.
Salam,HK
Sent from Yahoo Mail on Android
On Sat, Jul 22, 2017 at 22:11, rwant...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com> wrote:
Selamat malam om HK
Terimakasih banyak om HK atas jawabannya..sesuai yg diharapkan.
Salam hormat,
Ruswanto
Powered by Telkomsel BlackBerry®From: "hendrik karnadi
hendrikkarn...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>Sender: belajar-excel@yahoogroups.comDate: Sat,
22 Jul 2017 14:33:10 +0000 (UTC)To: rwant...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com>ReplyTo:
belajar-excel@yahoogroups.comSubject: Re: [belajar-excel] Rumus mencari
pembagian SHU per anggota
Hai Ruswanto,
Coba ketik formula :=F6/SUM($F$6:$F$51)*55000000 pada sel H6 lalu copy ke bawah.
Salam,HK
On Saturday, July 22, 2017, 6:25:50 PM GMT+7, rwant...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Kepada yth
Rekan rekan dan master
Di group belajar excel
Assalamualaikum,
Saya mohon bantuannya kepada rekan rekan dan master, bagaimana rumusnya untuk
menghitung pembagian shu sesuai jumlah bulan kepesertaan anggota, adapun
penjelasannya ada di file yg sy lampirkan.
Atas bantuannya saya ucapkan banyak terimakasih.
Wassalam
Ruswanto
Powered by Telkomsel BlackBerry®
#yiv1927953897 #yiv1927953897 -- #yiv1927953897ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1927953897
#yiv1927953897ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1927953897
#yiv1927953897ygrp-mkp #yiv1927953897hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1927953897 #yiv1927953897ygrp-mkp #yiv1927953897ads
{margin-bottom:10px;}#yiv1927953897 #yiv1927953897ygrp-mkp .yiv1927953897ad
{padding:0 0;}#yiv1927953897 #yiv1927953897ygrp-mkp .yiv1927953897ad p
{margin:0;}#yiv1927953897 #yiv1927953897ygrp-mkp .yiv1927953897ad a
{color:#0000ff;text-decoration:none;}#yiv1927953897 #yiv1927953897ygrp-sponsor
#yiv1927953897ygrp-lc {font-family:Arial;}#yiv1927953897
#yiv1927953897ygrp-sponsor #yiv1927953897ygrp-lc #yiv1927953897hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1927953897
#yiv1927953897ygrp-sponsor #yiv1927953897ygrp-lc .yiv1927953897ad
{margin-bottom:10px;padding:0 0;}#yiv1927953897 #yiv1927953897actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1927953897
#yiv1927953897activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1927953897
#yiv1927953897activity span {font-weight:700;}#yiv1927953897
#yiv1927953897activity span:first-child
{text-transform:uppercase;}#yiv1927953897 #yiv1927953897activity span a
{color:#5085b6;text-decoration:none;}#yiv1927953897 #yiv1927953897activity span
span {color:#ff7900;}#yiv1927953897 #yiv1927953897activity span
.yiv1927953897underline {text-decoration:underline;}#yiv1927953897
.yiv1927953897attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1927953897 .yiv1927953897attach div a
{text-decoration:none;}#yiv1927953897 .yiv1927953897attach img
{border:none;padding-right:5px;}#yiv1927953897 .yiv1927953897attach label
{display:block;margin-bottom:5px;}#yiv1927953897 .yiv1927953897attach label a
{text-decoration:none;}#yiv1927953897 blockquote {margin:0 0 0
4px;}#yiv1927953897 .yiv1927953897bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1927953897
.yiv1927953897bold a {text-decoration:none;}#yiv1927953897 dd.yiv1927953897last
p a {font-family:Verdana;font-weight:700;}#yiv1927953897 dd.yiv1927953897last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1927953897
dd.yiv1927953897last p span.yiv1927953897yshortcuts
{margin-right:0;}#yiv1927953897 div.yiv1927953897attach-table div div a
{text-decoration:none;}#yiv1927953897 div.yiv1927953897attach-table
{width:400px;}#yiv1927953897 div.yiv1927953897file-title a, #yiv1927953897
div.yiv1927953897file-title a:active, #yiv1927953897
div.yiv1927953897file-title a:hover, #yiv1927953897 div.yiv1927953897file-title
a:visited {text-decoration:none;}#yiv1927953897 div.yiv1927953897photo-title a,
#yiv1927953897 div.yiv1927953897photo-title a:active, #yiv1927953897
div.yiv1927953897photo-title a:hover, #yiv1927953897
div.yiv1927953897photo-title a:visited {text-decoration:none;}#yiv1927953897
div#yiv1927953897ygrp-mlmsg #yiv1927953897ygrp-msg p a
span.yiv1927953897yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1927953897
.yiv1927953897green {color:#628c2a;}#yiv1927953897 .yiv1927953897MsoNormal
{margin:0 0 0 0;}#yiv1927953897 o {font-size:0;}#yiv1927953897
#yiv1927953897photos div {float:left;width:72px;}#yiv1927953897
#yiv1927953897photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1927953897
#yiv1927953897photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1927953897
#yiv1927953897reco-category {font-size:77%;}#yiv1927953897
#yiv1927953897reco-desc {font-size:77%;}#yiv1927953897 .yiv1927953897replbq
{margin:4px;}#yiv1927953897 #yiv1927953897ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1927953897 #yiv1927953897ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1927953897
#yiv1927953897ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1927953897
#yiv1927953897ygrp-mlmsg select, #yiv1927953897 input, #yiv1927953897 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1927953897
#yiv1927953897ygrp-mlmsg pre, #yiv1927953897 code {font:115%
monospace;}#yiv1927953897 #yiv1927953897ygrp-mlmsg *
{line-height:1.22em;}#yiv1927953897 #yiv1927953897ygrp-mlmsg #yiv1927953897logo
{padding-bottom:10px;}#yiv1927953897 #yiv1927953897ygrp-msg p a
{font-family:Verdana;}#yiv1927953897 #yiv1927953897ygrp-msg
p#yiv1927953897attach-count span {color:#1E66AE;font-weight:700;}#yiv1927953897
#yiv1927953897ygrp-reco #yiv1927953897reco-head
{color:#ff7900;font-weight:700;}#yiv1927953897 #yiv1927953897ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1927953897 #yiv1927953897ygrp-sponsor
#yiv1927953897ov li a {font-size:130%;text-decoration:none;}#yiv1927953897
#yiv1927953897ygrp-sponsor #yiv1927953897ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1927953897
#yiv1927953897ygrp-sponsor #yiv1927953897ov ul {margin:0;padding:0 0 0
8px;}#yiv1927953897 #yiv1927953897ygrp-text
{font-family:Georgia;}#yiv1927953897 #yiv1927953897ygrp-text p {margin:0 0 1em
0;}#yiv1927953897 #yiv1927953897ygrp-text tt {font-size:120%;}#yiv1927953897
#yiv1927953897ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1927953897
