Dear DD,
Dicoba rumus berikut :Kepuluhan : =ROUNDUP(B3,-1)Keratusan : =ROUNDUP(B3,-2)
Regards,Andrie
From: "Dede pmaho_l...@nabatisnack.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, April 24, 2015 4:33 PM
Subject: [belajar-excel] Rubah Angka [1 Attachment]
Dear BeExceler, Apa rumus yg tepat untuk kolom warna kuning yah?
Salam DD
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed. If you have
received this email in error please send it back to the person that sent it to
you. Any views or opinions presented are solely those of its author and do not
necessarily represent those of NABATI or any of its subsidiary companies.
Unauthorized publication, use, dissemination, forwarding, printing or copying
of this email and its associated attachments is strictly prohibited.
#yiv3903567296 #yiv3903567296 -- #yiv3903567296ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3903567296
#yiv3903567296ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3903567296
#yiv3903567296ygrp-mkp #yiv3903567296hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3903567296 #yiv3903567296ygrp-mkp #yiv3903567296ads
{margin-bottom:10px;}#yiv3903567296 #yiv3903567296ygrp-mkp .yiv3903567296ad
{padding:0 0;}#yiv3903567296 #yiv3903567296ygrp-mkp .yiv3903567296ad p
{margin:0;}#yiv3903567296 #yiv3903567296ygrp-mkp .yiv3903567296ad a
{color:#0000ff;text-decoration:none;}#yiv3903567296 #yiv3903567296ygrp-sponsor
#yiv3903567296ygrp-lc {font-family:Arial;}#yiv3903567296
#yiv3903567296ygrp-sponsor #yiv3903567296ygrp-lc #yiv3903567296hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3903567296
#yiv3903567296ygrp-sponsor #yiv3903567296ygrp-lc .yiv3903567296ad
{margin-bottom:10px;padding:0 0;}#yiv3903567296 #yiv3903567296actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3903567296
#yiv3903567296activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3903567296
#yiv3903567296activity span {font-weight:700;}#yiv3903567296
#yiv3903567296activity span:first-child
{text-transform:uppercase;}#yiv3903567296 #yiv3903567296activity span a
{color:#5085b6;text-decoration:none;}#yiv3903567296 #yiv3903567296activity span
span {color:#ff7900;}#yiv3903567296 #yiv3903567296activity span
.yiv3903567296underline {text-decoration:underline;}#yiv3903567296
.yiv3903567296attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3903567296 .yiv3903567296attach div a
{text-decoration:none;}#yiv3903567296 .yiv3903567296attach img
{border:none;padding-right:5px;}#yiv3903567296 .yiv3903567296attach label
{display:block;margin-bottom:5px;}#yiv3903567296 .yiv3903567296attach label a
{text-decoration:none;}#yiv3903567296 blockquote {margin:0 0 0
4px;}#yiv3903567296 .yiv3903567296bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3903567296
.yiv3903567296bold a {text-decoration:none;}#yiv3903567296 dd.yiv3903567296last
p a {font-family:Verdana;font-weight:700;}#yiv3903567296 dd.yiv3903567296last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3903567296
dd.yiv3903567296last p span.yiv3903567296yshortcuts
{margin-right:0;}#yiv3903567296 div.yiv3903567296attach-table div div a
{text-decoration:none;}#yiv3903567296 div.yiv3903567296attach-table
{width:400px;}#yiv3903567296 div.yiv3903567296file-title a, #yiv3903567296
div.yiv3903567296file-title a:active, #yiv3903567296
div.yiv3903567296file-title a:hover, #yiv3903567296 div.yiv3903567296file-title
a:visited {text-decoration:none;}#yiv3903567296 div.yiv3903567296photo-title a,
#yiv3903567296 div.yiv3903567296photo-title a:active, #yiv3903567296
div.yiv3903567296photo-title a:hover, #yiv3903567296
div.yiv3903567296photo-title a:visited {text-decoration:none;}#yiv3903567296
div#yiv3903567296ygrp-mlmsg #yiv3903567296ygrp-msg p a
span.yiv3903567296yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3903567296
.yiv3903567296green {color:#628c2a;}#yiv3903567296 .yiv3903567296MsoNormal
{margin:0 0 0 0;}#yiv3903567296 o {font-size:0;}#yiv3903567296
#yiv3903567296photos div {float:left;width:72px;}#yiv3903567296
#yiv3903567296photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3903567296
#yiv3903567296photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3903567296
#yiv3903567296reco-category {font-size:77%;}#yiv3903567296
#yiv3903567296reco-desc {font-size:77%;}#yiv3903567296 .yiv3903567296replbq
{margin:4px;}#yiv3903567296 #yiv3903567296ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3903567296 #yiv3903567296ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3903567296
#yiv3903567296ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3903567296
#yiv3903567296ygrp-mlmsg select, #yiv3903567296 input, #yiv3903567296 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3903567296
#yiv3903567296ygrp-mlmsg pre, #yiv3903567296 code {font:115%
monospace;}#yiv3903567296 #yiv3903567296ygrp-mlmsg *
{line-height:1.22em;}#yiv3903567296 #yiv3903567296ygrp-mlmsg #yiv3903567296logo
{padding-bottom:10px;}#yiv3903567296 #yiv3903567296ygrp-msg p a
{font-family:Verdana;}#yiv3903567296 #yiv3903567296ygrp-msg
p#yiv3903567296attach-count span {color:#1E66AE;font-weight:700;}#yiv3903567296
#yiv3903567296ygrp-reco #yiv3903567296reco-head
{color:#ff7900;font-weight:700;}#yiv3903567296 #yiv3903567296ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3903567296 #yiv3903567296ygrp-sponsor
#yiv3903567296ov li a {font-size:130%;text-decoration:none;}#yiv3903567296
#yiv3903567296ygrp-sponsor #yiv3903567296ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3903567296
#yiv3903567296ygrp-sponsor #yiv3903567296ov ul {margin:0;padding:0 0 0
8px;}#yiv3903567296 #yiv3903567296ygrp-text
{font-family:Georgia;}#yiv3903567296 #yiv3903567296ygrp-text p {margin:0 0 1em
0;}#yiv3903567296 #yiv3903567296ygrp-text tt {font-size:120%;}#yiv3903567296
#yiv3903567296ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3903567296
