Dear Mr. Kid, Fungsi IF berjalan dengan baik, Tapi ada satu hambatan lagi, sekalian belajar makro. Bisa gak kolom e sampai seterusnya menyesuakan secara otomatis berdasarkan di tanggal yg di input di sheel a4 dan b4, dst. Contoh. di sheet a4 tgl 28 Jan 2015, b4 tgl 01 Feb 2015,ketika sheel a4 dan b4 diinput maka kolom yang dr e dst secara langsung akan bertambah sesuai dengan tanggal di b4. Maaf merepotkan.
Krisan
Pada Selasa, 13 Januari 2015 8:29, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Krisan,
Bisa juga tanpa IF kok.
Mas Agus, pinjem formulanya ya
formula mas Agus yang bunyinya :
=IF((E$3<=$B4)*(E$3>=$A4),1,0)
diambil bagian pengkondisiannya saja menjadi :
=(E$3<=$B4)*(E$3>=$A4)
Hasil perbandingan menghasilkan TRUE atau FALSE yang setara 1 atau 0. Ketika
TRUE * TRUE maka setara 1 * 1 menghasilkan 1.
Wassalam,
Kid.
On Mon, Jan 12, 2015 at 5:18 PM, Krisan Flower [email protected]
[belajar-excel] <[email protected]> wrote:
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
#yiv8352324891 -- #yiv8352324891ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8352324891
#yiv8352324891ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8352324891
#yiv8352324891ygrp-mkp #yiv8352324891hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8352324891 #yiv8352324891ygrp-mkp #yiv8352324891ads
{margin-bottom:10px;}#yiv8352324891 #yiv8352324891ygrp-mkp .yiv8352324891ad
{padding:0 0;}#yiv8352324891 #yiv8352324891ygrp-mkp .yiv8352324891ad p
{margin:0;}#yiv8352324891 #yiv8352324891ygrp-mkp .yiv8352324891ad a
{color:#0000ff;text-decoration:none;}#yiv8352324891 #yiv8352324891ygrp-sponsor
#yiv8352324891ygrp-lc {font-family:Arial;}#yiv8352324891
#yiv8352324891ygrp-sponsor #yiv8352324891ygrp-lc #yiv8352324891hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8352324891
#yiv8352324891ygrp-sponsor #yiv8352324891ygrp-lc .yiv8352324891ad
{margin-bottom:10px;padding:0 0;}#yiv8352324891 #yiv8352324891actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8352324891
#yiv8352324891activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8352324891
#yiv8352324891activity span {font-weight:700;}#yiv8352324891
#yiv8352324891activity span:first-child
{text-transform:uppercase;}#yiv8352324891 #yiv8352324891activity span a
{color:#5085b6;text-decoration:none;}#yiv8352324891 #yiv8352324891activity span
span {color:#ff7900;}#yiv8352324891 #yiv8352324891activity span
.yiv8352324891underline {text-decoration:underline;}#yiv8352324891
.yiv8352324891attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8352324891 .yiv8352324891attach div a
{text-decoration:none;}#yiv8352324891 .yiv8352324891attach img
{border:none;padding-right:5px;}#yiv8352324891 .yiv8352324891attach label
{display:block;margin-bottom:5px;}#yiv8352324891 .yiv8352324891attach label a
{text-decoration:none;}#yiv8352324891 blockquote {margin:0 0 0
4px;}#yiv8352324891 .yiv8352324891bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8352324891
.yiv8352324891bold a {text-decoration:none;}#yiv8352324891 dd.yiv8352324891last
p a {font-family:Verdana;font-weight:700;}#yiv8352324891 dd.yiv8352324891last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8352324891
dd.yiv8352324891last p span.yiv8352324891yshortcuts
{margin-right:0;}#yiv8352324891 div.yiv8352324891attach-table div div a
{text-decoration:none;}#yiv8352324891 div.yiv8352324891attach-table
{width:400px;}#yiv8352324891 div.yiv8352324891file-title a, #yiv8352324891
div.yiv8352324891file-title a:active, #yiv8352324891
div.yiv8352324891file-title a:hover, #yiv8352324891 div.yiv8352324891file-title
a:visited {text-decoration:none;}#yiv8352324891 div.yiv8352324891photo-title a,
#yiv8352324891 div.yiv8352324891photo-title a:active, #yiv8352324891
div.yiv8352324891photo-title a:hover, #yiv8352324891
div.yiv8352324891photo-title a:visited {text-decoration:none;}#yiv8352324891
div#yiv8352324891ygrp-mlmsg #yiv8352324891ygrp-msg p a
span.yiv8352324891yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8352324891
.yiv8352324891green {color:#628c2a;}#yiv8352324891 .yiv8352324891MsoNormal
{margin:0 0 0 0;}#yiv8352324891 o {font-size:0;}#yiv8352324891
#yiv8352324891photos div {float:left;width:72px;}#yiv8352324891
#yiv8352324891photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8352324891
#yiv8352324891photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8352324891
#yiv8352324891reco-category {font-size:77%;}#yiv8352324891
#yiv8352324891reco-desc {font-size:77%;}#yiv8352324891 .yiv8352324891replbq
{margin:4px;}#yiv8352324891 #yiv8352324891ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8352324891 #yiv8352324891ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8352324891
#yiv8352324891ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8352324891
#yiv8352324891ygrp-mlmsg select, #yiv8352324891 input, #yiv8352324891 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8352324891
#yiv8352324891ygrp-mlmsg pre, #yiv8352324891 code {font:115%
monospace;}#yiv8352324891 #yiv8352324891ygrp-mlmsg *
{line-height:1.22em;}#yiv8352324891 #yiv8352324891ygrp-mlmsg #yiv8352324891logo
{padding-bottom:10px;}#yiv8352324891 #yiv8352324891ygrp-msg p a
{font-family:Verdana;}#yiv8352324891 #yiv8352324891ygrp-msg
p#yiv8352324891attach-count span {color:#1E66AE;font-weight:700;}#yiv8352324891
#yiv8352324891ygrp-reco #yiv8352324891reco-head
{color:#ff7900;font-weight:700;}#yiv8352324891 #yiv8352324891ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8352324891 #yiv8352324891ygrp-sponsor
#yiv8352324891ov li a {font-size:130%;text-decoration:none;}#yiv8352324891
#yiv8352324891ygrp-sponsor #yiv8352324891ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8352324891
#yiv8352324891ygrp-sponsor #yiv8352324891ov ul {margin:0;padding:0 0 0
8px;}#yiv8352324891 #yiv8352324891ygrp-text
{font-family:Georgia;}#yiv8352324891 #yiv8352324891ygrp-text p {margin:0 0 1em
0;}#yiv8352324891 #yiv8352324891ygrp-text tt {font-size:120%;}#yiv8352324891
#yiv8352324891ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8352324891
Mohon Bantuan.xlsx
Description: MS-Excel 2007 spreadsheet
