Dear Pak nang Agus,
Formulanya berjalan dengan baik pak, Saya gak kepikiran pake fungsi If, bener2
blank bru sadar klo if bisa dipake. hehehe. Makasi Pak..
Krisan
Pada Senin, 12 Januari 2015 11:24, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Krisan,
Coba di E4 diketik Formula:
=IF((E$3<=$B4)*(E$3>=$A4),1,0)
copy ke semua cell yang dibutuhkan
salam
nangAgus
2015-01-10 12:31 GMT+07:00 Krisan Flower [email protected]
[belajar-excel] <[email protected]>:
Dear Para Master,
Saya menghadapi kesulitan niy untuk memberi tanda satu secara otomatis pada
template sheet saya,kalau saya kerjakan manual resiko terjadinya kesalahan
sangat besar apa lagi data yg jumlahnya lumayan banyak.
berikut saya lampirkan contoh kasus saya,
Terimakasih ,
Krisan
#yiv7672428430 #yiv7672428430 -- #yiv7672428430ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7672428430
#yiv7672428430ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7672428430
#yiv7672428430ygrp-mkp #yiv7672428430hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7672428430 #yiv7672428430ygrp-mkp #yiv7672428430ads
{margin-bottom:10px;}#yiv7672428430 #yiv7672428430ygrp-mkp .yiv7672428430ad
{padding:0 0;}#yiv7672428430 #yiv7672428430ygrp-mkp .yiv7672428430ad p
{margin:0;}#yiv7672428430 #yiv7672428430ygrp-mkp .yiv7672428430ad a
{color:#0000ff;text-decoration:none;}#yiv7672428430 #yiv7672428430ygrp-sponsor
#yiv7672428430ygrp-lc {font-family:Arial;}#yiv7672428430
#yiv7672428430ygrp-sponsor #yiv7672428430ygrp-lc #yiv7672428430hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7672428430
#yiv7672428430ygrp-sponsor #yiv7672428430ygrp-lc .yiv7672428430ad
{margin-bottom:10px;padding:0 0;}#yiv7672428430 #yiv7672428430actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7672428430
#yiv7672428430activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7672428430
#yiv7672428430activity span {font-weight:700;}#yiv7672428430
#yiv7672428430activity span:first-child
{text-transform:uppercase;}#yiv7672428430 #yiv7672428430activity span a
{color:#5085b6;text-decoration:none;}#yiv7672428430 #yiv7672428430activity span
span {color:#ff7900;}#yiv7672428430 #yiv7672428430activity span
.yiv7672428430underline {text-decoration:underline;}#yiv7672428430
.yiv7672428430attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7672428430 .yiv7672428430attach div a
{text-decoration:none;}#yiv7672428430 .yiv7672428430attach img
{border:none;padding-right:5px;}#yiv7672428430 .yiv7672428430attach label
{display:block;margin-bottom:5px;}#yiv7672428430 .yiv7672428430attach label a
{text-decoration:none;}#yiv7672428430 blockquote {margin:0 0 0
4px;}#yiv7672428430 .yiv7672428430bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7672428430
.yiv7672428430bold a {text-decoration:none;}#yiv7672428430 dd.yiv7672428430last
p a {font-family:Verdana;font-weight:700;}#yiv7672428430 dd.yiv7672428430last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7672428430
dd.yiv7672428430last p span.yiv7672428430yshortcuts
{margin-right:0;}#yiv7672428430 div.yiv7672428430attach-table div div a
{text-decoration:none;}#yiv7672428430 div.yiv7672428430attach-table
{width:400px;}#yiv7672428430 div.yiv7672428430file-title a, #yiv7672428430
div.yiv7672428430file-title a:active, #yiv7672428430
div.yiv7672428430file-title a:hover, #yiv7672428430 div.yiv7672428430file-title
a:visited {text-decoration:none;}#yiv7672428430 div.yiv7672428430photo-title a,
#yiv7672428430 div.yiv7672428430photo-title a:active, #yiv7672428430
div.yiv7672428430photo-title a:hover, #yiv7672428430
div.yiv7672428430photo-title a:visited {text-decoration:none;}#yiv7672428430
div#yiv7672428430ygrp-mlmsg #yiv7672428430ygrp-msg p a
span.yiv7672428430yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7672428430
.yiv7672428430green {color:#628c2a;}#yiv7672428430 .yiv7672428430MsoNormal
{margin:0 0 0 0;}#yiv7672428430 o {font-size:0;}#yiv7672428430
#yiv7672428430photos div {float:left;width:72px;}#yiv7672428430
#yiv7672428430photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7672428430
#yiv7672428430photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7672428430
#yiv7672428430reco-category {font-size:77%;}#yiv7672428430
#yiv7672428430reco-desc {font-size:77%;}#yiv7672428430 .yiv7672428430replbq
{margin:4px;}#yiv7672428430 #yiv7672428430ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7672428430 #yiv7672428430ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7672428430
#yiv7672428430ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7672428430
#yiv7672428430ygrp-mlmsg select, #yiv7672428430 input, #yiv7672428430 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7672428430
#yiv7672428430ygrp-mlmsg pre, #yiv7672428430 code {font:115%
monospace;}#yiv7672428430 #yiv7672428430ygrp-mlmsg *
{line-height:1.22em;}#yiv7672428430 #yiv7672428430ygrp-mlmsg #yiv7672428430logo
{padding-bottom:10px;}#yiv7672428430 #yiv7672428430ygrp-msg p a
{font-family:Verdana;}#yiv7672428430 #yiv7672428430ygrp-msg
p#yiv7672428430attach-count span {color:#1E66AE;font-weight:700;}#yiv7672428430
#yiv7672428430ygrp-reco #yiv7672428430reco-head
{color:#ff7900;font-weight:700;}#yiv7672428430 #yiv7672428430ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7672428430 #yiv7672428430ygrp-sponsor
#yiv7672428430ov li a {font-size:130%;text-decoration:none;}#yiv7672428430
#yiv7672428430ygrp-sponsor #yiv7672428430ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7672428430
#yiv7672428430ygrp-sponsor #yiv7672428430ov ul {margin:0;padding:0 0 0
8px;}#yiv7672428430 #yiv7672428430ygrp-text
{font-family:Georgia;}#yiv7672428430 #yiv7672428430ygrp-text p {margin:0 0 1em
0;}#yiv7672428430 #yiv7672428430ygrp-text tt {font-size:120%;}#yiv7672428430
#yiv7672428430ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7672428430
