Saya coba pake excel bisa, ini aja pak dikembangkan pake function "IF" dalam
excel
A B C D 1 Data Rumus hasil Rumus 2 150,506,505
100,000,000 =A3-(MOD(A3,100000000)) 3 50,506,505 =+A3-C3
50,000,000 =A4-(MOD(A4,10000000)) 4 506,505 =+A4-C4 500,000
=A5-(MOD(A5,100000)) 5 6,505 =+A5-C5 6,000
=A6-(MOD(A6,1000)) 6 505 =+A6-C6 500
=A7-(MOD(A7,100)) 7 5 =+A7-C7 5 =A8-(MOD(A8,1))
yang perlu ditambahkan adalah kalau ketemu angka "nol" dalam angka maka
angka 0 pembagi modnya berkurang 2 bukan 1, bisa dilihat contoh diatas.
semoga membantu
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
agus muhardi,A.Md
Sent: Thursday, April 17, 2008 4:24 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [indoprog-vb] membagi nominal menjadi milyaran, ratusan juta, jutaan,
ribuan, ratusan dst
Dear Pakar n Suhu
Mohon bantuan jika diantara suhu2 dan pakar2 ada yang menyimpan contoh rumus
pada microsoft excel
atau bahasa pemograman untuk membagi nominal menjadi milyaran, ratusan juta,
jutaan, ribuan, ratusan dst
Contoh Nilai Nominalnya :
10.251.357.123
Maka akan terbagi secara otomatis mejadi pecahannya:
10.000.000.000
200.000.000
50.000.000
1.000.000
300.000
50.000
7.000
100
20
3
B.Reg's
Ardi
Nb:
-Saya sertakan file excel nya.
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
#ygrp-mkp { BORDER-RIGHT: #d8d8d8 1px solid; PADDING-RIGHT: 14px; BORDER-TOP:
#d8d8d8 1px solid; PADDING-LEFT: 14px; PADDING-BOTTOM: 0px; MARGIN: 14px 0px;
BORDER-LEFT: #d8d8d8 1px solid; PADDING-TOP: 0px; BORDER-BOTTOM: #d8d8d8 1px
solid; FONT-FAMILY: Arial } #ygrp-mkp HR { BORDER-RIGHT: #d8d8d8 1px solid;
BORDER-TOP: #d8d8d8 1px solid; BORDER-LEFT: #d8d8d8 1px solid; BORDER-BOTTOM:
#d8d8d8 1px solid } #ygrp-mkp #hd { FONT-WEIGHT: bold; FONT-SIZE: 85%; MARGIN:
10px 0px; COLOR: #628c2a; LINE-HEIGHT: 122% } #ygrp-mkp #ads { MARGIN-BOTTOM:
10px } #ygrp-mkp .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM:
0px; PADDING-TOP: 0px } #ygrp-mkp .ad A { COLOR: #0000ff; TEXT-DECORATION:
none } #ygrp-sponsor #ygrp-lc { FONT-FAMILY: Arial } #ygrp-sponsor #ygrp-lc
#hd { FONT-WEIGHT: bold; FONT-SIZE: 78%; MARGIN: 10px 0px; LINE-HEIGHT: 122% }
#ygrp-sponsor #ygrp-lc .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px;
MARGIN-BOTTOM: 10px; PADDING-BOTTOM: 0px;
PADDING-TOP: 0px } #ygrp-mlmsg { FONT-SIZE: small; FONT-FAMILY:
arial,helvetica,clean,sans-serif } #ygrp-mlmsg TABLE { } #ygrp-mlmsg SELECT {
FONT: 99% arial,helvetica,clean,sans-serif } INPUT { FONT: 99%
arial,helvetica,clean,sans-serif } TEXTAREA { FONT: 99%
arial,helvetica,clean,sans-serif } #ygrp-mlmsg PRE { FONT: 100% monospace }
CODE { FONT: 100% monospace } #ygrp-mlmsg { LINE-HEIGHT: 1.22em } #ygrp-text
{ FONT-FAMILY: Georgia } #ygrp-text P { MARGIN: 0px 0px 1em } #ygrp-tpmsgs {
CLEAR: both; FONT-FAMILY: Arial } #ygrp-vitnav { FONT-SIZE: 77%; MARGIN: 0px;
PADDING-TOP: 10px; FONT-FAMILY: Verdana } #ygrp-vitnav A { PADDING-RIGHT: 1px;
PADDING-LEFT: 1px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-actbar {
CLEAR: both; MARGIN: 25px 0px; COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN:
right } #ygrp-actbar .left { FLOAT: left; WHITE-SPACE: nowrap } .bld {
FONT-WEIGHT: bold } #ygrp-grft { PADDING-RIGHT: 0px; PADDING-LEFT: 0px;
FONT-SIZE: 77%;
PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT-FAMILY: Verdana } #ygrp-ft {
PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE:
77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana } #ygrp-mlmsg
#logo { PADDING-BOTTOM: 10px } #ygrp-reco { PADDING-RIGHT: 0px; PADDING-LEFT:
0px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-reco
#reco-head { FONT-WEIGHT: bold; COLOR: #ff7900 } #reco-grpname { MARGIN-TOP:
10px; FONT-WEIGHT: bold } #reco-category { FONT-SIZE: 77% } #reco-desc {
FONT-SIZE: 77% } #ygrp-vital { PADDING-RIGHT: 0px; PADDING-LEFT: 8px;
MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 8px; PADDING-TOP: 2px; BACKGROUND-COLOR:
#e0ecee } #ygrp-vital #vithd { FONT-WEIGHT: bold; FONT-SIZE: 77%;
TEXT-TRANSFORM: uppercase; COLOR: #333; FONT-FAMILY: Verdana } #ygrp-vital UL {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 2px 0px;
PADDING-TOP: 0px } #ygrp-vital UL LI { CLEAR: both; BORDER-RIGHT:
#e0ecee 1px solid; BORDER-TOP: #e0ecee 1px solid; BORDER-LEFT: #e0ecee 1px
solid; BORDER-BOTTOM: #e0ecee 1px solid; LIST-STYLE-TYPE: none } #ygrp-vital UL
LI .ct { PADDING-RIGHT: 0.5em; FONT-WEIGHT: bold; FLOAT: right; WIDTH: 2em;
COLOR: #ff7900; TEXT-ALIGN: right } #ygrp-vital UL LI .cat { FONT-WEIGHT: bold
} #ygrp-vital A { TEXT-DECORATION: none } #ygrp-vital A:hover {
TEXT-DECORATION: underline } #ygrp-sponsor #hd { FONT-SIZE: 77%; COLOR: #999 }
#ygrp-sponsor #ov { PADDING-RIGHT: 13px; PADDING-LEFT: 13px; MARGIN-BOTTOM:
20px; PADDING-BOTTOM: 6px; PADDING-TOP: 6px; BACKGROUND-COLOR: #e0ecee }
#ygrp-sponsor #ov UL { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; PADDING-BOTTOM:
0px; MARGIN: 0px; PADDING-TOP: 0px } #ygrp-sponsor #ov LI { PADDING-RIGHT:
0px; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 6px; PADDING-TOP: 6px;
LIST-STYLE-TYPE: square } #ygrp-sponsor #ov LI A { FONT-SIZE: 130%;
TEXT-DECORATION: none } #ygrp-sponsor #nc { PADDING-RIGHT: 8px;
PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px;
BACKGROUND-COLOR: #eee } #ygrp-sponsor .ad { PADDING-RIGHT: 0px; PADDING-LEFT:
0px; PADDING-BOTTOM: 8px; PADDING-TOP: 8px } #ygrp-sponsor .ad #hd1 {
FONT-WEIGHT: bold; FONT-SIZE: 100%; COLOR: #628c2a; LINE-HEIGHT: 122%;
FONT-FAMILY: Arial } #ygrp-sponsor .ad A { TEXT-DECORATION: none }
#ygrp-sponsor .ad A:hover { TEXT-DECORATION: underline } #ygrp-sponsor .ad P {
MARGIN: 0px } o { FONT-SIZE: 0px } .MsoNormal { MARGIN: 0px } #ygrp-text TT
{ FONT-SIZE: 120% } BLOCKQUOTE { MARGIN: 0px 0px 0px 4px } .replbq { }
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
