[belajar-excel] Rumus mencari pembagian SHU per anggota [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] Rumus mencari pembagian SHU per anggota [1 Attachment]

Milis Belajar Excel mailing list
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®

=?utf-8?B?RGF0YSBDb250b2ggUGVtYmFnaWFuIFNIVS54bHN4?= (18K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Rumus mencari pembagian SHU per anggota

Milis Belajar Excel mailing list
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, [hidden email] [belajar-excel] <[hidden email]> 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®
 
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: Re: [belajar-excel] Rumus mencari pembagian SHU per anggota

Milis Belajar Excel mailing list
Selamat malam om HK

Terimakasih banyak om HK atas jawabannya..sesuai yg diharapkan.

Salam hormat,
Ruswanto
Powered by Telkomsel BlackBerry®

-----Original Message-----
From: "hendrik karnadi [hidden email] [belajar-excel]" <[hidden email]>
Sender: [hidden email]
Date: Sat, 22 Jul 2017 14:33:10
To: [hidden email] [belajar-excel]<[hidden email]>
Reply-To: [hidden email]
Subject: 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, [hidden email] [belajar-excel] <[hidden email]> 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®
 
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Bls: Re: [belajar-excel] Rumus mencari pembagian SHU per anggota

Milis Belajar Excel mailing list
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, [hidden email] [belajar-excel]<[hidden email]> wrote:      
 Selamat malam om HK

Terimakasih banyak om HK atas jawabannya..sesuai yg diharapkan.

Salam hormat,
Ruswanto
Powered by Telkomsel BlackBerry®From:  "hendrik karnadi [hidden email] [belajar-excel]" <[hidden email]>Sender:  [hidden email]: Sat, 22 Jul 2017 14:33:10 +0000 (UTC)To: [hidden email] [belajar-excel]<[hidden email]>ReplyTo:  [hidden email]: 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, [hidden email] [belajar-excel] <[hidden email]> 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  
Loading...