Mr Kidmohon kemurahan hatinya untuk menerangkan kepada kami
N( f10 )+1 , 1 )=Left( f4 )
ini hal baru buat saya
__Winarno__
Pada Kamis, 16 April 2015 3:37, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Pinjem formulanya ya om...
Tampaknya bisa disusun seperti juga : (katanya untuk formula di F11)
=IF( Mid( " kkj" , N( f10 )+1 , 1 )=Left( f4 ) , $c$10 , "" )
*** jika regional setting komputer setempat adalah Indonesian, ganti karakter
koma menjadi titik koma
*** sesuaikan dengan kebutuhan tentang penggunaan absolute reference (tanda $)
nya
Kayanya sih bisa...
Wassalam,
Kid
On Thu, Apr 16, 2015 at 7:21 PM, Winov X [email protected] [belajar-excel]
<[email protected]> wrote:
coba ini
untuk di F11
=IF(OR((F4&F10)="kam1";(F4&F10)="kam2";(F4&F10)="jum3");$C$10;"")
semoga sesuai harapan
__Winarno__
Pada Rabu, 15 April 2015 23:50, "'Tuti Hartati'
[email protected] [belajar-excel]"
<[email protected]> menulis:
Terimakasih mas winarno atas bantuannya tetapi kalau saya ingin
menambahkan rumusnya yaitu (jika hari kamis shift 1 dan shift 2 maka munculkan
jumlah peserta, jika shift 3 dan libur munculkan kosong), (jika hari jumat
shift 3 maka munculkan jumlah peserta jika shift 1,shift 2 dan libur munculkan
kosong), bagaimana ya rumus if nya karena untuk rumus if saya kurang
paham.Terimakasih sebelumnya. Tuti hartati From:
[email protected] [mailto:[email protected]]
Sent: Thursday, April 16, 2015 9:06 AM
To: [email protected]
Subject: Bls: [belajar-excel] Rumus untuk jumlah peserta coba iniuntuk kolom
F, selanjutnya copas =IF(ISNUMBER(F7);$C$7;"")
__Winarno__ Pada Rabu, 15 April 2015 18:46, "'Tuti Hartati'
[email protected] [belajar-excel]"
<[email protected]> menulis: Mohon dibantu, saya ingin membuat
jadwal belajar untuk karyawan, dimana sudah ada kolom shift, group dan jumlah
peserta.Dan saya ingin dibawah kolom shift dimunculkan juga jumlah pesertanya,
bagaimana ya rumusnya, mohon bantuannya. Terimakasih.Tuti Hartati
#yiv7879092667 #yiv7879092667 -- #yiv7879092667ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7879092667
#yiv7879092667ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7879092667
#yiv7879092667ygrp-mkp #yiv7879092667hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7879092667 #yiv7879092667ygrp-mkp #yiv7879092667ads
{margin-bottom:10px;}#yiv7879092667 #yiv7879092667ygrp-mkp .yiv7879092667ad
{padding:0 0;}#yiv7879092667 #yiv7879092667ygrp-mkp .yiv7879092667ad p
{margin:0;}#yiv7879092667 #yiv7879092667ygrp-mkp .yiv7879092667ad a
{color:#0000ff;text-decoration:none;}#yiv7879092667 #yiv7879092667ygrp-sponsor
#yiv7879092667ygrp-lc {font-family:Arial;}#yiv7879092667
#yiv7879092667ygrp-sponsor #yiv7879092667ygrp-lc #yiv7879092667hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7879092667
#yiv7879092667ygrp-sponsor #yiv7879092667ygrp-lc .yiv7879092667ad
{margin-bottom:10px;padding:0 0;}#yiv7879092667 #yiv7879092667actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7879092667
#yiv7879092667activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7879092667
#yiv7879092667activity span {font-weight:700;}#yiv7879092667
#yiv7879092667activity span:first-child
{text-transform:uppercase;}#yiv7879092667 #yiv7879092667activity span a
{color:#5085b6;text-decoration:none;}#yiv7879092667 #yiv7879092667activity span
span {color:#ff7900;}#yiv7879092667 #yiv7879092667activity span
.yiv7879092667underline {text-decoration:underline;}#yiv7879092667
.yiv7879092667attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7879092667 .yiv7879092667attach div a
{text-decoration:none;}#yiv7879092667 .yiv7879092667attach img
{border:none;padding-right:5px;}#yiv7879092667 .yiv7879092667attach label
{display:block;margin-bottom:5px;}#yiv7879092667 .yiv7879092667attach label a
{text-decoration:none;}#yiv7879092667 blockquote {margin:0 0 0
4px;}#yiv7879092667 .yiv7879092667bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7879092667
.yiv7879092667bold a {text-decoration:none;}#yiv7879092667 dd.yiv7879092667last
p a {font-family:Verdana;font-weight:700;}#yiv7879092667 dd.yiv7879092667last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7879092667
dd.yiv7879092667last p span.yiv7879092667yshortcuts
{margin-right:0;}#yiv7879092667 div.yiv7879092667attach-table div div a
{text-decoration:none;}#yiv7879092667 div.yiv7879092667attach-table
{width:400px;}#yiv7879092667 div.yiv7879092667file-title a, #yiv7879092667
div.yiv7879092667file-title a:active, #yiv7879092667
div.yiv7879092667file-title a:hover, #yiv7879092667 div.yiv7879092667file-title
a:visited {text-decoration:none;}#yiv7879092667 div.yiv7879092667photo-title a,
#yiv7879092667 div.yiv7879092667photo-title a:active, #yiv7879092667
div.yiv7879092667photo-title a:hover, #yiv7879092667
div.yiv7879092667photo-title a:visited {text-decoration:none;}#yiv7879092667
div#yiv7879092667ygrp-mlmsg #yiv7879092667ygrp-msg p a
span.yiv7879092667yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7879092667
.yiv7879092667green {color:#628c2a;}#yiv7879092667 .yiv7879092667MsoNormal
{margin:0 0 0 0;}#yiv7879092667 o {font-size:0;}#yiv7879092667
#yiv7879092667photos div {float:left;width:72px;}#yiv7879092667
#yiv7879092667photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7879092667
#yiv7879092667photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7879092667
#yiv7879092667reco-category {font-size:77%;}#yiv7879092667
#yiv7879092667reco-desc {font-size:77%;}#yiv7879092667 .yiv7879092667replbq
{margin:4px;}#yiv7879092667 #yiv7879092667ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7879092667 #yiv7879092667ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7879092667
#yiv7879092667ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7879092667
#yiv7879092667ygrp-mlmsg select, #yiv7879092667 input, #yiv7879092667 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7879092667
#yiv7879092667ygrp-mlmsg pre, #yiv7879092667 code {font:115%
monospace;}#yiv7879092667 #yiv7879092667ygrp-mlmsg *
{line-height:1.22em;}#yiv7879092667 #yiv7879092667ygrp-mlmsg #yiv7879092667logo
{padding-bottom:10px;}#yiv7879092667 #yiv7879092667ygrp-msg p a
{font-family:Verdana;}#yiv7879092667 #yiv7879092667ygrp-msg
p#yiv7879092667attach-count span {color:#1E66AE;font-weight:700;}#yiv7879092667
#yiv7879092667ygrp-reco #yiv7879092667reco-head
{color:#ff7900;font-weight:700;}#yiv7879092667 #yiv7879092667ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7879092667 #yiv7879092667ygrp-sponsor
#yiv7879092667ov li a {font-size:130%;text-decoration:none;}#yiv7879092667
#yiv7879092667ygrp-sponsor #yiv7879092667ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7879092667
#yiv7879092667ygrp-sponsor #yiv7879092667ov ul {margin:0;padding:0 0 0
8px;}#yiv7879092667 #yiv7879092667ygrp-text
{font-family:Georgia;}#yiv7879092667 #yiv7879092667ygrp-text p {margin:0 0 1em
0;}#yiv7879092667 #yiv7879092667ygrp-text tt {font-size:120%;}#yiv7879092667
#yiv7879092667ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7879092667
