Terima kasih untuk pencerahannya pak hendrik, sangat membantu
Untuk pak mod, Sebelumnya mohon maaf bila pengiriman email lebih dari satu,
karna saya tidak tahu kok ternyata emailnya terkirim lebih dari satu, karna
sempat terkirim email balasan failure dari yahoo, jadi saya mengirim kembali.
Pada Senin, 19 Desember 2016 16:11, "hendrik karnadi
hendrikkarn...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:
Hai Tjahya,Coba ketik =IF(MOD(A3,10000),"",A3/$C$2) pada sel B3, kemudian
copy ke bawah.
Salam,HK
From: "Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Monday, 19 December 2016, 11:33
Subject: [belajar-excel] Bagaimana membuat urutan nominal dalam kelipatan
tertentu [1 Attachment]
Dear para master excel,
Mohon bantuannya untuk kasus membuat urutan 1,2,3 dstnya tetapi dalam kelipatan
tertentu,misalnya 1000 s/d 100.000 tetapi saya hanya mau menghitung dalam
kelipatan 10.000 saja. bagaimana ya?supaya lebih jelas, saya akan berikan
contoh kasus dalam file terlampir. terima kasih
#yiv9674910211 #yiv9674910211 -- #yiv9674910211ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9674910211
#yiv9674910211ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9674910211
#yiv9674910211ygrp-mkp #yiv9674910211hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9674910211 #yiv9674910211ygrp-mkp #yiv9674910211ads
{margin-bottom:10px;}#yiv9674910211 #yiv9674910211ygrp-mkp .yiv9674910211ad
{padding:0 0;}#yiv9674910211 #yiv9674910211ygrp-mkp .yiv9674910211ad p
{margin:0;}#yiv9674910211 #yiv9674910211ygrp-mkp .yiv9674910211ad a
{color:#0000ff;text-decoration:none;}#yiv9674910211 #yiv9674910211ygrp-sponsor
#yiv9674910211ygrp-lc {font-family:Arial;}#yiv9674910211
#yiv9674910211ygrp-sponsor #yiv9674910211ygrp-lc #yiv9674910211hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9674910211
#yiv9674910211ygrp-sponsor #yiv9674910211ygrp-lc .yiv9674910211ad
{margin-bottom:10px;padding:0 0;}#yiv9674910211 #yiv9674910211actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9674910211
#yiv9674910211activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9674910211
#yiv9674910211activity span {font-weight:700;}#yiv9674910211
#yiv9674910211activity span:first-child
{text-transform:uppercase;}#yiv9674910211 #yiv9674910211activity span a
{color:#5085b6;text-decoration:none;}#yiv9674910211 #yiv9674910211activity span
span {color:#ff7900;}#yiv9674910211 #yiv9674910211activity span
.yiv9674910211underline {text-decoration:underline;}#yiv9674910211
.yiv9674910211attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9674910211 .yiv9674910211attach div a
{text-decoration:none;}#yiv9674910211 .yiv9674910211attach img
{border:none;padding-right:5px;}#yiv9674910211 .yiv9674910211attach label
{display:block;margin-bottom:5px;}#yiv9674910211 .yiv9674910211attach label a
{text-decoration:none;}#yiv9674910211 blockquote {margin:0 0 0
4px;}#yiv9674910211 .yiv9674910211bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9674910211
.yiv9674910211bold a {text-decoration:none;}#yiv9674910211 dd.yiv9674910211last
p a {font-family:Verdana;font-weight:700;}#yiv9674910211 dd.yiv9674910211last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9674910211
dd.yiv9674910211last p span.yiv9674910211yshortcuts
{margin-right:0;}#yiv9674910211 div.yiv9674910211attach-table div div a
{text-decoration:none;}#yiv9674910211 div.yiv9674910211attach-table
{width:400px;}#yiv9674910211 div.yiv9674910211file-title a, #yiv9674910211
div.yiv9674910211file-title a:active, #yiv9674910211
div.yiv9674910211file-title a:hover, #yiv9674910211 div.yiv9674910211file-title
a:visited {text-decoration:none;}#yiv9674910211 div.yiv9674910211photo-title a,
#yiv9674910211 div.yiv9674910211photo-title a:active, #yiv9674910211
div.yiv9674910211photo-title a:hover, #yiv9674910211
div.yiv9674910211photo-title a:visited {text-decoration:none;}#yiv9674910211
div#yiv9674910211ygrp-mlmsg #yiv9674910211ygrp-msg p a
span.yiv9674910211yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9674910211
.yiv9674910211green {color:#628c2a;}#yiv9674910211 .yiv9674910211MsoNormal
{margin:0 0 0 0;}#yiv9674910211 o {font-size:0;}#yiv9674910211
#yiv9674910211photos div {float:left;width:72px;}#yiv9674910211
#yiv9674910211photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9674910211
#yiv9674910211photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9674910211
#yiv9674910211reco-category {font-size:77%;}#yiv9674910211
#yiv9674910211reco-desc {font-size:77%;}#yiv9674910211 .yiv9674910211replbq
{margin:4px;}#yiv9674910211 #yiv9674910211ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9674910211 #yiv9674910211ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9674910211
#yiv9674910211ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9674910211
#yiv9674910211ygrp-mlmsg select, #yiv9674910211 input, #yiv9674910211 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9674910211
#yiv9674910211ygrp-mlmsg pre, #yiv9674910211 code {font:115%
monospace;}#yiv9674910211 #yiv9674910211ygrp-mlmsg *
{line-height:1.22em;}#yiv9674910211 #yiv9674910211ygrp-mlmsg #yiv9674910211logo
{padding-bottom:10px;}#yiv9674910211 #yiv9674910211ygrp-msg p a
{font-family:Verdana;}#yiv9674910211 #yiv9674910211ygrp-msg
p#yiv9674910211attach-count span {color:#1E66AE;font-weight:700;}#yiv9674910211
#yiv9674910211ygrp-reco #yiv9674910211reco-head
{color:#ff7900;font-weight:700;}#yiv9674910211 #yiv9674910211ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9674910211 #yiv9674910211ygrp-sponsor
#yiv9674910211ov li a {font-size:130%;text-decoration:none;}#yiv9674910211
#yiv9674910211ygrp-sponsor #yiv9674910211ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9674910211
#yiv9674910211ygrp-sponsor #yiv9674910211ov ul {margin:0;padding:0 0 0
8px;}#yiv9674910211 #yiv9674910211ygrp-text
{font-family:Georgia;}#yiv9674910211 #yiv9674910211ygrp-text p {margin:0 0 1em
0;}#yiv9674910211 #yiv9674910211ygrp-text tt {font-size:120%;}#yiv9674910211
#yiv9674910211ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9674910211
