Dear Mr. Samsudin & Mr. Toby,mantaabb, terimakasih pencerahannya.
On Sunday, January 17, 2016 2:00 PM, "Samsudin [email protected]
[belajar-excel]" <[email protected]> wrote:
Mungkin saya hanya urun rembuk, gunakan formula Iferror, seperti ini :
=IFERROR(SUMIFS($F$3:$F$19,$C$3:$C$19,"TCM",$D$3:$D$19,"Critical",$E$3:$E$19,"Emergency")/K4,0)
Terima kasihSamsudin From: [email protected]
[mailto:[email protected]]
Sent: Sunday, January 17, 2016 6:56 AM
To: [email protected]
Cc: Ribowo Bebo Lumiting Asmoro
Subject: [belajar-excel] Pembulatan hasil SUMIF [1 Attachment] Selamat Pagi,
dear exceller, saya mau minta tolong untuk kasus pada excel terlampir apakah
bisa dilakukan pembulatan, pada hasil penghitungan rata2 dengan SUMIF.
Sebelumnya terimakasih.
|
---------------------------------------------------------------------------------------------------
This message (including any attachments) contains confidential information
intended
for a specific individual and purpose, and is protected by law. If you are not
the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or
the
taking of any action based on it, is strictly prohibited. No liability or
responsibility
is accepted if information or data is, for whatever reason corrupted or does
not reach
its intended recipient. No warranty is given that this email is free of
viruses. The
views expressed in this email are, unless otherwise stated, those of the author
and
not those of the Company or its management. The Company reserves the right to
monitor,
intercept and block emails addressed to its users or take any other action in
accordance
with its email use policy. |
#yiv8738674315 #yiv8738674315 -- #yiv8738674315ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8738674315
#yiv8738674315ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8738674315
#yiv8738674315ygrp-mkp #yiv8738674315hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8738674315 #yiv8738674315ygrp-mkp #yiv8738674315ads
{margin-bottom:10px;}#yiv8738674315 #yiv8738674315ygrp-mkp .yiv8738674315ad
{padding:0 0;}#yiv8738674315 #yiv8738674315ygrp-mkp .yiv8738674315ad p
{margin:0;}#yiv8738674315 #yiv8738674315ygrp-mkp .yiv8738674315ad a
{color:#0000ff;text-decoration:none;}#yiv8738674315 #yiv8738674315ygrp-sponsor
#yiv8738674315ygrp-lc {font-family:Arial;}#yiv8738674315
#yiv8738674315ygrp-sponsor #yiv8738674315ygrp-lc #yiv8738674315hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8738674315
#yiv8738674315ygrp-sponsor #yiv8738674315ygrp-lc .yiv8738674315ad
{margin-bottom:10px;padding:0 0;}#yiv8738674315 #yiv8738674315actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8738674315
#yiv8738674315activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8738674315
#yiv8738674315activity span {font-weight:700;}#yiv8738674315
#yiv8738674315activity span:first-child
{text-transform:uppercase;}#yiv8738674315 #yiv8738674315activity span a
{color:#5085b6;text-decoration:none;}#yiv8738674315 #yiv8738674315activity span
span {color:#ff7900;}#yiv8738674315 #yiv8738674315activity span
.yiv8738674315underline {text-decoration:underline;}#yiv8738674315
.yiv8738674315attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8738674315 .yiv8738674315attach div a
{text-decoration:none;}#yiv8738674315 .yiv8738674315attach img
{border:none;padding-right:5px;}#yiv8738674315 .yiv8738674315attach label
{display:block;margin-bottom:5px;}#yiv8738674315 .yiv8738674315attach label a
{text-decoration:none;}#yiv8738674315 blockquote {margin:0 0 0
4px;}#yiv8738674315 .yiv8738674315bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8738674315
.yiv8738674315bold a {text-decoration:none;}#yiv8738674315 dd.yiv8738674315last
p a {font-family:Verdana;font-weight:700;}#yiv8738674315 dd.yiv8738674315last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8738674315
dd.yiv8738674315last p span.yiv8738674315yshortcuts
{margin-right:0;}#yiv8738674315 div.yiv8738674315attach-table div div a
{text-decoration:none;}#yiv8738674315 div.yiv8738674315attach-table
{width:400px;}#yiv8738674315 div.yiv8738674315file-title a, #yiv8738674315
div.yiv8738674315file-title a:active, #yiv8738674315
div.yiv8738674315file-title a:hover, #yiv8738674315 div.yiv8738674315file-title
a:visited {text-decoration:none;}#yiv8738674315 div.yiv8738674315photo-title a,
#yiv8738674315 div.yiv8738674315photo-title a:active, #yiv8738674315
div.yiv8738674315photo-title a:hover, #yiv8738674315
div.yiv8738674315photo-title a:visited {text-decoration:none;}#yiv8738674315
div#yiv8738674315ygrp-mlmsg #yiv8738674315ygrp-msg p a
span.yiv8738674315yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8738674315
.yiv8738674315green {color:#628c2a;}#yiv8738674315 .yiv8738674315MsoNormal
{margin:0 0 0 0;}#yiv8738674315 o {font-size:0;}#yiv8738674315
#yiv8738674315photos div {float:left;width:72px;}#yiv8738674315
#yiv8738674315photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8738674315
#yiv8738674315photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8738674315
#yiv8738674315reco-category {font-size:77%;}#yiv8738674315
#yiv8738674315reco-desc {font-size:77%;}#yiv8738674315 .yiv8738674315replbq
{margin:4px;}#yiv8738674315 #yiv8738674315ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8738674315 #yiv8738674315ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8738674315
#yiv8738674315ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8738674315
#yiv8738674315ygrp-mlmsg select, #yiv8738674315 input, #yiv8738674315 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8738674315
#yiv8738674315ygrp-mlmsg pre, #yiv8738674315 code {font:115%
monospace;}#yiv8738674315 #yiv8738674315ygrp-mlmsg *
{line-height:1.22em;}#yiv8738674315 #yiv8738674315ygrp-mlmsg #yiv8738674315logo
{padding-bottom:10px;}#yiv8738674315 #yiv8738674315ygrp-msg p a
{font-family:Verdana;}#yiv8738674315 #yiv8738674315ygrp-msg
p#yiv8738674315attach-count span {color:#1E66AE;font-weight:700;}#yiv8738674315
#yiv8738674315ygrp-reco #yiv8738674315reco-head
{color:#ff7900;font-weight:700;}#yiv8738674315 #yiv8738674315ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8738674315 #yiv8738674315ygrp-sponsor
#yiv8738674315ov li a {font-size:130%;text-decoration:none;}#yiv8738674315
#yiv8738674315ygrp-sponsor #yiv8738674315ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8738674315
#yiv8738674315ygrp-sponsor #yiv8738674315ov ul {margin:0;padding:0 0 0
8px;}#yiv8738674315 #yiv8738674315ygrp-text
{font-family:Georgia;}#yiv8738674315 #yiv8738674315ygrp-text p {margin:0 0 1em
0;}#yiv8738674315 #yiv8738674315ygrp-text tt {font-size:120%;}#yiv8738674315
#yiv8738674315ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8738674315
