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 odongna...@yahoo.com 
[belajar-excel]" <belajar-excel@yahoogroups.com> 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 rudhied...@yahoo.com 
[belajar-excel]" <belajar-excel@yahoogroups.com> 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 odongna...@yahoo.com 
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:



     bisa pake formula "ROUNDUP" br,


odong nando





     Pada Senin, 9 November 2015 14:43, "Rudhie rudhied...@yahoo.com 
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:



     Dear Be Exceller
Selamat siangMohon bantuannya bagaimana membuat formula perhitungan kelipatan 
untuk decimal dibelakang angka.Contoh file saya lampirkan.
Terima Kasih









     #yiv1908581611 #yiv1908581611 -- #yiv1908581611ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1908581611 
#yiv1908581611ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1908581611 
#yiv1908581611ygrp-mkp #yiv1908581611hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1908581611 #yiv1908581611ygrp-mkp #yiv1908581611ads 
{margin-bottom:10px;}#yiv1908581611 #yiv1908581611ygrp-mkp .yiv1908581611ad 
{padding:0 0;}#yiv1908581611 #yiv1908581611ygrp-mkp .yiv1908581611ad p 
{margin:0;}#yiv1908581611 #yiv1908581611ygrp-mkp .yiv1908581611ad a 
{color:#0000ff;text-decoration:none;}#yiv1908581611 #yiv1908581611ygrp-sponsor 
#yiv1908581611ygrp-lc {font-family:Arial;}#yiv1908581611 
#yiv1908581611ygrp-sponsor #yiv1908581611ygrp-lc #yiv1908581611hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1908581611 
#yiv1908581611ygrp-sponsor #yiv1908581611ygrp-lc .yiv1908581611ad 
{margin-bottom:10px;padding:0 0;}#yiv1908581611 #yiv1908581611actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1908581611 
#yiv1908581611activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1908581611
 #yiv1908581611activity span {font-weight:700;}#yiv1908581611 
#yiv1908581611activity span:first-child 
{text-transform:uppercase;}#yiv1908581611 #yiv1908581611activity span a 
{color:#5085b6;text-decoration:none;}#yiv1908581611 #yiv1908581611activity span 
span {color:#ff7900;}#yiv1908581611 #yiv1908581611activity span 
.yiv1908581611underline {text-decoration:underline;}#yiv1908581611 
.yiv1908581611attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1908581611 .yiv1908581611attach div a 
{text-decoration:none;}#yiv1908581611 .yiv1908581611attach img 
{border:none;padding-right:5px;}#yiv1908581611 .yiv1908581611attach label 
{display:block;margin-bottom:5px;}#yiv1908581611 .yiv1908581611attach label a 
{text-decoration:none;}#yiv1908581611 blockquote {margin:0 0 0 
4px;}#yiv1908581611 .yiv1908581611bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1908581611 
.yiv1908581611bold a {text-decoration:none;}#yiv1908581611 dd.yiv1908581611last 
p a {font-family:Verdana;font-weight:700;}#yiv1908581611 dd.yiv1908581611last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1908581611 
dd.yiv1908581611last p span.yiv1908581611yshortcuts 
{margin-right:0;}#yiv1908581611 div.yiv1908581611attach-table div div a 
{text-decoration:none;}#yiv1908581611 div.yiv1908581611attach-table 
{width:400px;}#yiv1908581611 div.yiv1908581611file-title a, #yiv1908581611 
div.yiv1908581611file-title a:active, #yiv1908581611 
div.yiv1908581611file-title a:hover, #yiv1908581611 div.yiv1908581611file-title 
a:visited {text-decoration:none;}#yiv1908581611 div.yiv1908581611photo-title a, 
#yiv1908581611 div.yiv1908581611photo-title a:active, #yiv1908581611 
div.yiv1908581611photo-title a:hover, #yiv1908581611 
div.yiv1908581611photo-title a:visited {text-decoration:none;}#yiv1908581611 
div#yiv1908581611ygrp-mlmsg #yiv1908581611ygrp-msg p a 
span.yiv1908581611yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1908581611 
.yiv1908581611green {color:#628c2a;}#yiv1908581611 .yiv1908581611MsoNormal 
{margin:0 0 0 0;}#yiv1908581611 o {font-size:0;}#yiv1908581611 
#yiv1908581611photos div {float:left;width:72px;}#yiv1908581611 
#yiv1908581611photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv1908581611 
#yiv1908581611photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1908581611
 #yiv1908581611reco-category {font-size:77%;}#yiv1908581611 
#yiv1908581611reco-desc {font-size:77%;}#yiv1908581611 .yiv1908581611replbq 
{margin:4px;}#yiv1908581611 #yiv1908581611ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1908581611 #yiv1908581611ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1908581611 
#yiv1908581611ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1908581611 
#yiv1908581611ygrp-mlmsg select, #yiv1908581611 input, #yiv1908581611 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1908581611 
#yiv1908581611ygrp-mlmsg pre, #yiv1908581611 code {font:115% 
monospace;}#yiv1908581611 #yiv1908581611ygrp-mlmsg * 
{line-height:1.22em;}#yiv1908581611 #yiv1908581611ygrp-mlmsg #yiv1908581611logo 
{padding-bottom:10px;}#yiv1908581611 #yiv1908581611ygrp-msg p a 
{font-family:Verdana;}#yiv1908581611 #yiv1908581611ygrp-msg 
p#yiv1908581611attach-count span {color:#1E66AE;font-weight:700;}#yiv1908581611 
#yiv1908581611ygrp-reco #yiv1908581611reco-head 
{color:#ff7900;font-weight:700;}#yiv1908581611 #yiv1908581611ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv1908581611 #yiv1908581611ygrp-sponsor 
#yiv1908581611ov li a {font-size:130%;text-decoration:none;}#yiv1908581611 
#yiv1908581611ygrp-sponsor #yiv1908581611ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1908581611 
#yiv1908581611ygrp-sponsor #yiv1908581611ov ul {margin:0;padding:0 0 0 
8px;}#yiv1908581611 #yiv1908581611ygrp-text 
{font-family:Georgia;}#yiv1908581611 #yiv1908581611ygrp-text p {margin:0 0 1em 
0;}#yiv1908581611 #yiv1908581611ygrp-text tt {font-size:120%;}#yiv1908581611 
#yiv1908581611ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv1908581611


  

Attachment: hitung kelipatan.xlsx
Description: MS-Excel 2007 spreadsheet

  • [belajar... Rudhie rudhied...@yahoo.com [belajar-excel]
    • Bls... odong nando odongna...@yahoo.com [belajar-excel]
      • ... Rudhie rudhied...@yahoo.com [belajar-excel]
        • ... odong nando odongna...@yahoo.com [belajar-excel]
          • ... Rudhie rudhied...@yahoo.com [belajar-excel]
            • ... 'Heri Pamungkas ( Gmail )' ghery.dha...@gmail.com [belajar-excel]
            • ... odong nando odongna...@yahoo.com [belajar-excel]
              • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... Rudhie rudhied...@yahoo.com [belajar-excel]
                • ... 'Riki' ricky45chi...@yahoo.co.id [belajar-excel]
                • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... odong nando odongna...@yahoo.com [belajar-excel]
                • ... 'Riki' ricky45chi...@yahoo.co.id [belajar-excel]
                • ... odong nando odongna...@yahoo.com [belajar-excel]
                • ... 'Riki' ricky45chi...@yahoo.co.id [belajar-excel]

Kirim email ke