Sdr. Herlambang, gunakan Conditonal Formatting untuk setiap kelompok rata-rata
On Friday, December 12, 2014 4:38 PM, "Herlambang Wibowo
[email protected] [XL-mania]" <[email protected]> wrote:
Mohon bantuannnya master,
bagaimana caranya agar nilai2 yang kembar (berwarna kuning) tersebut bisa di
bedakan tanpa nilai dibelakang koma (pembulatan)
Karena nilai pokok yang besar bila di rata2 dan di bulatkan menjadi sama dengan
yang nilai pokoknya kecil.
Apa tidak bisa di ubah menjadi 14,15, 16 ?
Terima kasih bantuannya... #yiv2311890132 #yiv2311890132 --
#yiv2311890132ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv2311890132 #yiv2311890132ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv2311890132 #yiv2311890132ygrp-mkp #yiv2311890132hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2311890132 #yiv2311890132ygrp-mkp #yiv2311890132ads
{margin-bottom:10px;}#yiv2311890132 #yiv2311890132ygrp-mkp .yiv2311890132ad
{padding:0 0;}#yiv2311890132 #yiv2311890132ygrp-mkp .yiv2311890132ad p
{margin:0;}#yiv2311890132 #yiv2311890132ygrp-mkp .yiv2311890132ad a
{color:#0000ff;text-decoration:none;}#yiv2311890132 #yiv2311890132ygrp-sponsor
#yiv2311890132ygrp-lc {font-family:Arial;}#yiv2311890132
#yiv2311890132ygrp-sponsor #yiv2311890132ygrp-lc #yiv2311890132hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2311890132
#yiv2311890132ygrp-sponsor #yiv2311890132ygrp-lc .yiv2311890132ad
{margin-bottom:10px;padding:0 0;}#yiv2311890132 #yiv2311890132actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2311890132
#yiv2311890132activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2311890132
#yiv2311890132activity span {font-weight:700;}#yiv2311890132
#yiv2311890132activity span:first-child
{text-transform:uppercase;}#yiv2311890132 #yiv2311890132activity span a
{color:#5085b6;text-decoration:none;}#yiv2311890132 #yiv2311890132activity span
span {color:#ff7900;}#yiv2311890132 #yiv2311890132activity span
.yiv2311890132underline {text-decoration:underline;}#yiv2311890132
.yiv2311890132attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2311890132 .yiv2311890132attach div a
{text-decoration:none;}#yiv2311890132 .yiv2311890132attach img
{border:none;padding-right:5px;}#yiv2311890132 .yiv2311890132attach label
{display:block;margin-bottom:5px;}#yiv2311890132 .yiv2311890132attach label a
{text-decoration:none;}#yiv2311890132 blockquote {margin:0 0 0
4px;}#yiv2311890132 .yiv2311890132bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2311890132
.yiv2311890132bold a {text-decoration:none;}#yiv2311890132 dd.yiv2311890132last
p a {font-family:Verdana;font-weight:700;}#yiv2311890132 dd.yiv2311890132last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2311890132
dd.yiv2311890132last p span.yiv2311890132yshortcuts
{margin-right:0;}#yiv2311890132 div.yiv2311890132attach-table div div a
{text-decoration:none;}#yiv2311890132 div.yiv2311890132attach-table
{width:400px;}#yiv2311890132 div.yiv2311890132file-title a, #yiv2311890132
div.yiv2311890132file-title a:active, #yiv2311890132
div.yiv2311890132file-title a:hover, #yiv2311890132 div.yiv2311890132file-title
a:visited {text-decoration:none;}#yiv2311890132 div.yiv2311890132photo-title a,
#yiv2311890132 div.yiv2311890132photo-title a:active, #yiv2311890132
div.yiv2311890132photo-title a:hover, #yiv2311890132
div.yiv2311890132photo-title a:visited {text-decoration:none;}#yiv2311890132
div#yiv2311890132ygrp-mlmsg #yiv2311890132ygrp-msg p a
span.yiv2311890132yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2311890132
.yiv2311890132green {color:#628c2a;}#yiv2311890132 .yiv2311890132MsoNormal
{margin:0 0 0 0;}#yiv2311890132 o {font-size:0;}#yiv2311890132
#yiv2311890132photos div {float:left;width:72px;}#yiv2311890132
#yiv2311890132photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2311890132
#yiv2311890132photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2311890132
#yiv2311890132reco-category {font-size:77%;}#yiv2311890132
#yiv2311890132reco-desc {font-size:77%;}#yiv2311890132 .yiv2311890132replbq
{margin:4px;}#yiv2311890132 #yiv2311890132ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2311890132 #yiv2311890132ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2311890132
#yiv2311890132ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2311890132
#yiv2311890132ygrp-mlmsg select, #yiv2311890132 input, #yiv2311890132 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2311890132
#yiv2311890132ygrp-mlmsg pre, #yiv2311890132 code {font:115%
monospace;}#yiv2311890132 #yiv2311890132ygrp-mlmsg *
{line-height:1.22em;}#yiv2311890132 #yiv2311890132ygrp-mlmsg #yiv2311890132logo
{padding-bottom:10px;}#yiv2311890132 #yiv2311890132ygrp-msg p a
{font-family:Verdana;}#yiv2311890132 #yiv2311890132ygrp-msg
p#yiv2311890132attach-count span {color:#1E66AE;font-weight:700;}#yiv2311890132
#yiv2311890132ygrp-reco #yiv2311890132reco-head
{color:#ff7900;font-weight:700;}#yiv2311890132 #yiv2311890132ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2311890132 #yiv2311890132ygrp-sponsor
#yiv2311890132ov li a {font-size:130%;text-decoration:none;}#yiv2311890132
#yiv2311890132ygrp-sponsor #yiv2311890132ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2311890132
#yiv2311890132ygrp-sponsor #yiv2311890132ov ul {margin:0;padding:0 0 0
8px;}#yiv2311890132 #yiv2311890132ygrp-text
{font-family:Georgia;}#yiv2311890132 #yiv2311890132ygrp-text p {margin:0 0 1em
0;}#yiv2311890132 #yiv2311890132ygrp-text tt {font-size:120%;}#yiv2311890132
#yiv2311890132ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2311890132
rata-rata.xlsx
Description: MS-Excel 2007 spreadsheet
