coba tulis di F7 formula
=IF(("0,"&MID(D7;FIND(",";D7)+1;9))*1>=0,72;ROUNDUP(D7;0);D7)
bila regional komputer setempat english maka ganti karakter titik koma ";"
menjadi koma ",". br,
odong nando
Pada Selasa, 10 November 2015 14:36, "Rudhie [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Pak Odong
Mungkin penjelasan atas permasalahan yang saya miliki kurang detail
maksudnya.Untuk itu maka Saya lampirkan filenya kembali untuk jenis
permasalahannya, mungkin dengan demikian apa yang dimaksud oleh saya bisa
dipahami,dan semoga bisa membantu saya memberikan solusinya.
Terima kasih
Pada Selasa, 10 November 2015 10:50, "odong nando [email protected]
[belajar-excel]" <[email protected]> menulis:
saya pake formula roundup pada cell D6, dan saya copy ke cell yang lain
dibawahnya, tidak ada masalah kok
=ROUNDUP(C6;0)
bila regional komputer setempat english maka ganti karakter titik koma ";"
menjadi koma ",".
bila masih bermasalah bisa didiskusikan masalah nya dimana, biar anggota yang
lain mengetahui sebenarnya apa yang menjadi kendala pak rudhi. br,
odong nando
Pada Selasa, 10 November 2015 10:14, "Rudhie [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Pak Odong
Saya sudah coba menggunakan fungsi ROUNDUP, tetapi pembulatannya tidak sesuai
dengan keiinginan.Apakah bisa dibantu dengan contoh perumusannya?
Terima kasih
Pada Senin, 9 November 2015 17:34, "odong nando [email protected]
[belajar-excel]" <[email protected]> menulis:
bisa pake formula "ROUNDUP" br,
odong nando
Pada Senin, 9 November 2015 14:43, "Rudhie [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Be Exceller
Selamat siangMohon bantuannya bagaimana membuat formula perhitungan kelipatan
untuk decimal dibelakang angka.Contoh file saya lampirkan.
Terima Kasih
#yiv8578561422 -- #yiv8578561422ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8578561422
#yiv8578561422ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8578561422
#yiv8578561422ygrp-mkp #yiv8578561422hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8578561422 #yiv8578561422ygrp-mkp #yiv8578561422ads
{margin-bottom:10px;}#yiv8578561422 #yiv8578561422ygrp-mkp .yiv8578561422ad
{padding:0 0;}#yiv8578561422 #yiv8578561422ygrp-mkp .yiv8578561422ad p
{margin:0;}#yiv8578561422 #yiv8578561422ygrp-mkp .yiv8578561422ad a
{color:#0000ff;text-decoration:none;}#yiv8578561422 #yiv8578561422ygrp-sponsor
#yiv8578561422ygrp-lc {font-family:Arial;}#yiv8578561422
#yiv8578561422ygrp-sponsor #yiv8578561422ygrp-lc #yiv8578561422hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8578561422
#yiv8578561422ygrp-sponsor #yiv8578561422ygrp-lc .yiv8578561422ad
{margin-bottom:10px;padding:0 0;}#yiv8578561422 #yiv8578561422actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8578561422
#yiv8578561422activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8578561422
#yiv8578561422activity span {font-weight:700;}#yiv8578561422
#yiv8578561422activity span:first-child
{text-transform:uppercase;}#yiv8578561422 #yiv8578561422activity span a
{color:#5085b6;text-decoration:none;}#yiv8578561422 #yiv8578561422activity span
span {color:#ff7900;}#yiv8578561422 #yiv8578561422activity span
.yiv8578561422underline {text-decoration:underline;}#yiv8578561422
.yiv8578561422attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8578561422 .yiv8578561422attach div a
{text-decoration:none;}#yiv8578561422 .yiv8578561422attach img
{border:none;padding-right:5px;}#yiv8578561422 .yiv8578561422attach label
{display:block;margin-bottom:5px;}#yiv8578561422 .yiv8578561422attach label a
{text-decoration:none;}#yiv8578561422 blockquote {margin:0 0 0
4px;}#yiv8578561422 .yiv8578561422bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8578561422
.yiv8578561422bold a {text-decoration:none;}#yiv8578561422 dd.yiv8578561422last
p a {font-family:Verdana;font-weight:700;}#yiv8578561422 dd.yiv8578561422last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8578561422
dd.yiv8578561422last p span.yiv8578561422yshortcuts
{margin-right:0;}#yiv8578561422 div.yiv8578561422attach-table div div a
{text-decoration:none;}#yiv8578561422 div.yiv8578561422attach-table
{width:400px;}#yiv8578561422 div.yiv8578561422file-title a, #yiv8578561422
div.yiv8578561422file-title a:active, #yiv8578561422
div.yiv8578561422file-title a:hover, #yiv8578561422 div.yiv8578561422file-title
a:visited {text-decoration:none;}#yiv8578561422 div.yiv8578561422photo-title a,
#yiv8578561422 div.yiv8578561422photo-title a:active, #yiv8578561422
div.yiv8578561422photo-title a:hover, #yiv8578561422
div.yiv8578561422photo-title a:visited {text-decoration:none;}#yiv8578561422
div#yiv8578561422ygrp-mlmsg #yiv8578561422ygrp-msg p a
span.yiv8578561422yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8578561422
.yiv8578561422green {color:#628c2a;}#yiv8578561422 .yiv8578561422MsoNormal
{margin:0 0 0 0;}#yiv8578561422 o {font-size:0;}#yiv8578561422
#yiv8578561422photos div {float:left;width:72px;}#yiv8578561422
#yiv8578561422photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8578561422
#yiv8578561422photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8578561422
#yiv8578561422reco-category {font-size:77%;}#yiv8578561422
#yiv8578561422reco-desc {font-size:77%;}#yiv8578561422 .yiv8578561422replbq
{margin:4px;}#yiv8578561422 #yiv8578561422ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8578561422 #yiv8578561422ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8578561422
#yiv8578561422ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8578561422
#yiv8578561422ygrp-mlmsg select, #yiv8578561422 input, #yiv8578561422 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8578561422
#yiv8578561422ygrp-mlmsg pre, #yiv8578561422 code {font:115%
monospace;}#yiv8578561422 #yiv8578561422ygrp-mlmsg *
{line-height:1.22em;}#yiv8578561422 #yiv8578561422ygrp-mlmsg #yiv8578561422logo
{padding-bottom:10px;}#yiv8578561422 #yiv8578561422ygrp-msg p a
{font-family:Verdana;}#yiv8578561422 #yiv8578561422ygrp-msg
p#yiv8578561422attach-count span {color:#1E66AE;font-weight:700;}#yiv8578561422
#yiv8578561422ygrp-reco #yiv8578561422reco-head
{color:#ff7900;font-weight:700;}#yiv8578561422 #yiv8578561422ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8578561422 #yiv8578561422ygrp-sponsor
#yiv8578561422ov li a {font-size:130%;text-decoration:none;}#yiv8578561422
#yiv8578561422ygrp-sponsor #yiv8578561422ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8578561422
#yiv8578561422ygrp-sponsor #yiv8578561422ov ul {margin:0;padding:0 0 0
8px;}#yiv8578561422 #yiv8578561422ygrp-text
{font-family:Georgia;}#yiv8578561422 #yiv8578561422ygrp-text p {margin:0 0 1em
0;}#yiv8578561422 #yiv8578561422ygrp-text tt {font-size:120%;}#yiv8578561422
#yiv8578561422ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8578561422
