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