maaf ada tambahan Mas Zainul... angka 1000 (Seribu) (satu Ribu) terbilang nya
menjadi 1 (satu)terima kasih
On Tuesday, July 30, 2019, 03:52:21 PM GMT+7, Zainul Ulum
[email protected] [belajar-excel] <[email protected]> wrote:
Terimakasih koreksinya Mas Imam,
Akan saya koreksi formulanya.
Wassalam,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono [email protected] [belajar-excel]
Sent: Tuesday, July 30, 2019 1:56 PM
To: [email protected]
Subject: Re: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang
contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut
saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah...
mohon masukannya..
On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum
[email protected] [belajar-excel] <[email protected]> wrote:
Mas Imam,
Sudah aku tulis di
https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/
Untuk penjelasannya.
Terimakasih,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono [email protected] [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: [email protected]
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini
mohon pencerahan fungsi formula dan perbaikan pada formula yang ada
Terima kasih
#yiv7436276588 #yiv7436276588 -- #yiv7436276588ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7436276588
#yiv7436276588ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7436276588
#yiv7436276588ygrp-mkp #yiv7436276588hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7436276588 #yiv7436276588ygrp-mkp #yiv7436276588ads
{margin-bottom:10px;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad
{padding:0 0;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad p
{margin:0;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad a
{color:#0000ff;text-decoration:none;}#yiv7436276588 #yiv7436276588ygrp-sponsor
#yiv7436276588ygrp-lc {font-family:Arial;}#yiv7436276588
#yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc #yiv7436276588hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7436276588
#yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc .yiv7436276588ad
{margin-bottom:10px;padding:0 0;}#yiv7436276588 #yiv7436276588actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7436276588
#yiv7436276588activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7436276588
#yiv7436276588activity span {font-weight:700;}#yiv7436276588
#yiv7436276588activity span:first-child
{text-transform:uppercase;}#yiv7436276588 #yiv7436276588activity span a
{color:#5085b6;text-decoration:none;}#yiv7436276588 #yiv7436276588activity span
span {color:#ff7900;}#yiv7436276588 #yiv7436276588activity span
.yiv7436276588underline {text-decoration:underline;}#yiv7436276588
.yiv7436276588attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7436276588 .yiv7436276588attach div a
{text-decoration:none;}#yiv7436276588 .yiv7436276588attach img
{border:none;padding-right:5px;}#yiv7436276588 .yiv7436276588attach label
{display:block;margin-bottom:5px;}#yiv7436276588 .yiv7436276588attach label a
{text-decoration:none;}#yiv7436276588 blockquote {margin:0 0 0
4px;}#yiv7436276588 .yiv7436276588bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7436276588
.yiv7436276588bold a {text-decoration:none;}#yiv7436276588 dd.yiv7436276588last
p a {font-family:Verdana;font-weight:700;}#yiv7436276588 dd...yiv7436276588last
p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7436276588
dd.yiv7436276588last p span.yiv7436276588yshortcuts
{margin-right:0;}#yiv7436276588 div.yiv7436276588attach-table div div a
{text-decoration:none;}#yiv7436276588 div.yiv7436276588attach-table
{width:400px;}#yiv7436276588 div.yiv7436276588file-title a, #yiv7436276588
div.yiv7436276588file-title a:active, #yiv7436276588
div.yiv7436276588file-title a:hover, #yiv7436276588 div.yiv7436276588file-title
a:visited {text-decoration:none;}#yiv7436276588 div.yiv7436276588photo-title a,
#yiv7436276588 div.yiv7436276588photo-title a:active, #yiv7436276588
div.yiv7436276588photo-title a:hover, #yiv7436276588
div.yiv7436276588photo-title a:visited {text-decoration:none;}#yiv7436276588
div#yiv7436276588ygrp-mlmsg #yiv7436276588ygrp-msg p a
span.yiv7436276588yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7436276588
.yiv7436276588green {color:#628c2a;}#yiv7436276588 .yiv7436276588MsoNormal
{margin:0 0 0 0;}#yiv7436276588 o {font-size:0;}#yiv7436276588
#yiv7436276588photos div {float:left;width:72px;}#yiv7436276588
#yiv7436276588photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7436276588
#yiv7436276588photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7436276588
#yiv7436276588reco-category {font-size:77%;}#yiv7436276588
#yiv7436276588reco-desc {font-size:77%;}#yiv7436276588 .yiv7436276588replbq
{margin:4px;}#yiv7436276588 #yiv7436276588ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7436276588 #yiv7436276588ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7436276588
#yiv7436276588ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7436276588
#yiv7436276588ygrp-mlmsg select, #yiv7436276588 input, #yiv7436276588 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7436276588
#yiv7436276588ygrp-mlmsg pre, #yiv7436276588 code {font:115%
monospace;}#yiv7436276588 #yiv7436276588ygrp-mlmsg *
{line-height:1.22em;}#yiv7436276588 #yiv7436276588ygrp-mlmsg #yiv7436276588logo
{padding-bottom:10px;}#yiv7436276588 #yiv7436276588ygrp-msg p a
{font-family:Verdana;}#yiv7436276588 #yiv7436276588ygrp-msg
p#yiv7436276588attach-count span {color:#1E66AE;font-weight:700;}#yiv7436276588
#yiv7436276588ygrp-reco #yiv7436276588reco-head
{color:#ff7900;font-weight:700;}#yiv7436276588 #yiv7436276588ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7436276588 #yiv7436276588ygrp-sponsor
#yiv7436276588ov li a {font-size:130%;text-decoration:none;}#yiv7436276588
#yiv7436276588ygrp-sponsor #yiv7436276588ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7436276588
#yiv7436276588ygrp-sponsor #yiv7436276588ov ul {margin:0;padding:0 0 0
8px;}#yiv7436276588 #yiv7436276588ygrp-text
{font-family:Georgia;}#yiv7436276588 #yiv7436276588ygrp-text p {margin:0 0 1em
0;}#yiv7436276588 #yiv7436276588ygrp-text tt {font-size:120%;}#yiv7436276588
#yiv7436276588ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7436276588
