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
  

     

     #yiv3369225204 #yiv3369225204 -- #yiv3369225204ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3369225204 
#yiv3369225204ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3369225204 
#yiv3369225204ygrp-mkp #yiv3369225204hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3369225204 #yiv3369225204ygrp-mkp #yiv3369225204ads 
{margin-bottom:10px;}#yiv3369225204 #yiv3369225204ygrp-mkp .yiv3369225204ad 
{padding:0 0;}#yiv3369225204 #yiv3369225204ygrp-mkp .yiv3369225204ad p 
{margin:0;}#yiv3369225204 #yiv3369225204ygrp-mkp .yiv3369225204ad a 
{color:#0000ff;text-decoration:none;}#yiv3369225204 #yiv3369225204ygrp-sponsor 
#yiv3369225204ygrp-lc {font-family:Arial;}#yiv3369225204 
#yiv3369225204ygrp-sponsor #yiv3369225204ygrp-lc #yiv3369225204hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3369225204 
#yiv3369225204ygrp-sponsor #yiv3369225204ygrp-lc .yiv3369225204ad 
{margin-bottom:10px;padding:0 0;}#yiv3369225204 #yiv3369225204actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3369225204 
#yiv3369225204activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3369225204
 #yiv3369225204activity span {font-weight:700;}#yiv3369225204 
#yiv3369225204activity span:first-child 
{text-transform:uppercase;}#yiv3369225204 #yiv3369225204activity span a 
{color:#5085b6;text-decoration:none;}#yiv3369225204 #yiv3369225204activity span 
span {color:#ff7900;}#yiv3369225204 #yiv3369225204activity span 
.yiv3369225204underline {text-decoration:underline;}#yiv3369225204 
.yiv3369225204attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3369225204 .yiv3369225204attach div a 
{text-decoration:none;}#yiv3369225204 .yiv3369225204attach img 
{border:none;padding-right:5px;}#yiv3369225204 .yiv3369225204attach label 
{display:block;margin-bottom:5px;}#yiv3369225204 .yiv3369225204attach label a 
{text-decoration:none;}#yiv3369225204 blockquote {margin:0 0 0 
4px;}#yiv3369225204 .yiv3369225204bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3369225204 
.yiv3369225204bold a {text-decoration:none;}#yiv3369225204 dd.yiv3369225204last 
p a {font-family:Verdana;font-weight:700;}#yiv3369225204 dd.yiv3369225204last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3369225204 
dd.yiv3369225204last p span.yiv3369225204yshortcuts 
{margin-right:0;}#yiv3369225204 div.yiv3369225204attach-table div div a 
{text-decoration:none;}#yiv3369225204 div.yiv3369225204attach-table 
{width:400px;}#yiv3369225204 div.yiv3369225204file-title a, #yiv3369225204 
div.yiv3369225204file-title a:active, #yiv3369225204 
div.yiv3369225204file-title a:hover, #yiv3369225204 div.yiv3369225204file-title 
a:visited {text-decoration:none;}#yiv3369225204 div.yiv3369225204photo-title a, 
#yiv3369225204 div.yiv3369225204photo-title a:active, #yiv3369225204 
div.yiv3369225204photo-title a:hover, #yiv3369225204 
div.yiv3369225204photo-title a:visited {text-decoration:none;}#yiv3369225204 
div#yiv3369225204ygrp-mlmsg #yiv3369225204ygrp-msg p a 
span.yiv3369225204yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3369225204 
.yiv3369225204green {color:#628c2a;}#yiv3369225204 .yiv3369225204MsoNormal 
{margin:0 0 0 0;}#yiv3369225204 o {font-size:0;}#yiv3369225204 
#yiv3369225204photos div {float:left;width:72px;}#yiv3369225204 
#yiv3369225204photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv3369225204 
#yiv3369225204photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3369225204
 #yiv3369225204reco-category {font-size:77%;}#yiv3369225204 
#yiv3369225204reco-desc {font-size:77%;}#yiv3369225204 .yiv3369225204replbq 
{margin:4px;}#yiv3369225204 #yiv3369225204ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3369225204 #yiv3369225204ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3369225204 
#yiv3369225204ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3369225204 
#yiv3369225204ygrp-mlmsg select, #yiv3369225204 input, #yiv3369225204 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3369225204 
#yiv3369225204ygrp-mlmsg pre, #yiv3369225204 code {font:115% 
monospace;}#yiv3369225204 #yiv3369225204ygrp-mlmsg * 
{line-height:1.22em;}#yiv3369225204 #yiv3369225204ygrp-mlmsg #yiv3369225204logo 
{padding-bottom:10px;}#yiv3369225204 #yiv3369225204ygrp-msg p a 
{font-family:Verdana;}#yiv3369225204 #yiv3369225204ygrp-msg 
p#yiv3369225204attach-count span {color:#1E66AE;font-weight:700;}#yiv3369225204 
#yiv3369225204ygrp-reco #yiv3369225204reco-head 
{color:#ff7900;font-weight:700;}#yiv3369225204 #yiv3369225204ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv3369225204 #yiv3369225204ygrp-sponsor 
#yiv3369225204ov li a {font-size:130%;text-decoration:none;}#yiv3369225204 
#yiv3369225204ygrp-sponsor #yiv3369225204ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3369225204 
#yiv3369225204ygrp-sponsor #yiv3369225204ov ul {margin:0;padding:0 0 0 
8px;}#yiv3369225204 #yiv3369225204ygrp-text 
{font-family:Georgia;}#yiv3369225204 #yiv3369225204ygrp-text p {margin:0 0 1em 
0;}#yiv3369225204 #yiv3369225204ygrp-text tt {font-size:120%;}#yiv3369225204 
#yiv3369225204ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv3369225204 

  

Kirim email ke