hai...
coba formula
=IF(G3>H3;MIN(D3;G3);0)
ganti titik koma ":" dengan koma "," jika regional setting kompi setempat
english. br,
odong nando
Dari: "halak hita [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Senin, 30 Januari 2017 20:29
Judul: RE: [belajar-excel] Rumus IF
Dikolom "Add Stock" Jika di sistim lebih kecil dari Aktual, maka tidak
perlu diambil selisihnya untuk untuk masuk ke kolom "Add stok" alias Noll
sehingga ketika dibuat rumus dikolom "Qty Rev" maka hasilnya sama (Check vs Rev)
Namun apabila Qty Sistim > Aktual maka selisih kekurangannya diambil dari
"Check" namun tidak melebihi dari yang sistim
#yiv7101449087 #yiv7101449087 -- #yiv7101449087ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7101449087
#yiv7101449087ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7101449087
#yiv7101449087ygrp-mkp #yiv7101449087hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7101449087 #yiv7101449087ygrp-mkp #yiv7101449087ads
{margin-bottom:10px;}#yiv7101449087 #yiv7101449087ygrp-mkp .yiv7101449087ad
{padding:0 0;}#yiv7101449087 #yiv7101449087ygrp-mkp .yiv7101449087ad p
{margin:0;}#yiv7101449087 #yiv7101449087ygrp-mkp .yiv7101449087ad a
{color:#0000ff;text-decoration:none;}#yiv7101449087 #yiv7101449087ygrp-sponsor
#yiv7101449087ygrp-lc {font-family:Arial;}#yiv7101449087
#yiv7101449087ygrp-sponsor #yiv7101449087ygrp-lc #yiv7101449087hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7101449087
#yiv7101449087ygrp-sponsor #yiv7101449087ygrp-lc .yiv7101449087ad
{margin-bottom:10px;padding:0 0;}#yiv7101449087 #yiv7101449087actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7101449087
#yiv7101449087activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7101449087
#yiv7101449087activity span {font-weight:700;}#yiv7101449087
#yiv7101449087activity span:first-child
{text-transform:uppercase;}#yiv7101449087 #yiv7101449087activity span a
{color:#5085b6;text-decoration:none;}#yiv7101449087 #yiv7101449087activity span
span {color:#ff7900;}#yiv7101449087 #yiv7101449087activity span
.yiv7101449087underline {text-decoration:underline;}#yiv7101449087
.yiv7101449087attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7101449087 .yiv7101449087attach div a
{text-decoration:none;}#yiv7101449087 .yiv7101449087attach img
{border:none;padding-right:5px;}#yiv7101449087 .yiv7101449087attach label
{display:block;margin-bottom:5px;}#yiv7101449087 .yiv7101449087attach label a
{text-decoration:none;}#yiv7101449087 blockquote {margin:0 0 0
4px;}#yiv7101449087 .yiv7101449087bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7101449087
.yiv7101449087bold a {text-decoration:none;}#yiv7101449087 dd.yiv7101449087last
p a {font-family:Verdana;font-weight:700;}#yiv7101449087 dd.yiv7101449087last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7101449087
dd.yiv7101449087last p span.yiv7101449087yshortcuts
{margin-right:0;}#yiv7101449087 div.yiv7101449087attach-table div div a
{text-decoration:none;}#yiv7101449087 div.yiv7101449087attach-table
{width:400px;}#yiv7101449087 div.yiv7101449087file-title a, #yiv7101449087
div.yiv7101449087file-title a:active, #yiv7101449087
div.yiv7101449087file-title a:hover, #yiv7101449087 div.yiv7101449087file-title
a:visited {text-decoration:none;}#yiv7101449087 div.yiv7101449087photo-title a,
#yiv7101449087 div.yiv7101449087photo-title a:active, #yiv7101449087
div.yiv7101449087photo-title a:hover, #yiv7101449087
div.yiv7101449087photo-title a:visited {text-decoration:none;}#yiv7101449087
div#yiv7101449087ygrp-mlmsg #yiv7101449087ygrp-msg p a
span.yiv7101449087yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7101449087
.yiv7101449087green {color:#628c2a;}#yiv7101449087 .yiv7101449087MsoNormal
{margin:0 0 0 0;}#yiv7101449087 o {font-size:0;}#yiv7101449087
#yiv7101449087photos div {float:left;width:72px;}#yiv7101449087
#yiv7101449087photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7101449087
#yiv7101449087photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7101449087
#yiv7101449087reco-category {font-size:77%;}#yiv7101449087
#yiv7101449087reco-desc {font-size:77%;}#yiv7101449087 .yiv7101449087replbq
{margin:4px;}#yiv7101449087 #yiv7101449087ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7101449087 #yiv7101449087ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7101449087
#yiv7101449087ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7101449087
#yiv7101449087ygrp-mlmsg select, #yiv7101449087 input, #yiv7101449087 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7101449087
#yiv7101449087ygrp-mlmsg pre, #yiv7101449087 code {font:115%
monospace;}#yiv7101449087 #yiv7101449087ygrp-mlmsg *
{line-height:1.22em;}#yiv7101449087 #yiv7101449087ygrp-mlmsg #yiv7101449087logo
{padding-bottom:10px;}#yiv7101449087 #yiv7101449087ygrp-msg p a
{font-family:Verdana;}#yiv7101449087 #yiv7101449087ygrp-msg
p#yiv7101449087attach-count span {color:#1E66AE;font-weight:700;}#yiv7101449087
#yiv7101449087ygrp-reco #yiv7101449087reco-head
{color:#ff7900;font-weight:700;}#yiv7101449087 #yiv7101449087ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7101449087 #yiv7101449087ygrp-sponsor
#yiv7101449087ov li a {font-size:130%;text-decoration:none;}#yiv7101449087
#yiv7101449087ygrp-sponsor #yiv7101449087ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7101449087
#yiv7101449087ygrp-sponsor #yiv7101449087ov ul {margin:0;padding:0 0 0
8px;}#yiv7101449087 #yiv7101449087ygrp-text
{font-family:Georgia;}#yiv7101449087 #yiv7101449087ygrp-text p {margin:0 0 1em
0;}#yiv7101449087 #yiv7101449087ygrp-text tt {font-size:120%;}#yiv7101449087
#yiv7101449087ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7101449087
