Re: RE: [belajar-excel] Kolom Otomatis
Salam,
Terima kasih telah memberikan solusinya.
Untuk pertanyaan saya sebelumnya :
Saya membutuhkan tabel yang fleksible, jika ditambahkan entri baru tabel itu
akan bertambah.
Mohon bantuannya jika menggunakan macro bisa ..? karna ma'af saya belum mahir
dengan macro
Terima kasihHariyanto
Pada Kamis, 24 Mei 2018 10.54.00 GMT+8, 'M.Ade Alfarid' q...@kkmi.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Dear Depy,
Agar lebih teliti untuk perbedaan angka dan text, karena kaitannya dengan
formula di Excel.
Semoga lampiran bisa membantu.
Ade
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, May 24, 2018 9:17 AM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Kolom Otomatis
dear mas Depy,
pada sheet master data, di koloum F5, harusnya diinput angka (25), bukan text
(25 hari).
karena kolom F5 digunakan sbg formula perhitungan untuk sheet Januari
terima kasih
2018-05-24 7:45 GMT+07:00 depi Hariyanto depi.hari_ya...@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
Salam Rekan nang Agus,
Saya sudah lakukan pertanyaan pertama seperti yg di sarankan, namun hasilnya
menjadi kosong.
Pertanyaan kedua sebenarnya saya ingin membuat laporan, namun saya belum
mengetahui berapa tabel yang dibutuhkan.
Saya membutuhkan tabel yang fleksible, jika ditambahkan entri baru tabel itu
akan bertambah.
Saya lampirkan kembali Filenya.
Mohon pencerahannya dan terima kasih.
Salam..
Hariyanto
Pada Kamis, 24 Mei 2018 06.35.40 GMT+8, NangAgus nanga...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Dear Hariyanto,
untuk pertanyaan:
Jika Kolom C32 diisi maka kolom jumlah otomatis turun kebawah ..
* Buatlah data tersebut menjadi tabel (blok B5:L31 >> tab Insert >> Table >> OK)
Pada Kolom C4 jika di isi dengan tulisan 25 Hari, maka jasil tidak berubah
* Bukankah hari kerja diletakkan di sheet Master Data F5? Jadi yang diubah
adalah pada sheet Masterdata F5. Sedangkan disheet Januari C3 cukup ditulis
formula: =harikerja.
Regard
NangAgus
On 5/23/2018 8:17 PM, depi Hariyanto depi.hari_ya...@yahoo.co.id
[belajar-excel] wrote:
Dear Rekan2 Master Excel,
Mohon Bantuan dan pencerahannya, file terlampir
Terima kasih sebelumnya,
Salam
Hariyanto
Posted by: Pak Cik Lukman <pakcikluk...@gmail.com>
#yiv6061782425 #yiv6061782425 -- #yiv6061782425ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6061782425
#yiv6061782425ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6061782425
#yiv6061782425ygrp-mkp #yiv6061782425hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6061782425 #yiv6061782425ygrp-mkp #yiv6061782425ads
{margin-bottom:10px;}#yiv6061782425 #yiv6061782425ygrp-mkp .yiv6061782425ad
{padding:0 0;}#yiv6061782425 #yiv6061782425ygrp-mkp .yiv6061782425ad p
{margin:0;}#yiv6061782425 #yiv6061782425ygrp-mkp .yiv6061782425ad a
{color:#ff;text-decoration:none;}#yiv6061782425 #yiv6061782425ygrp-sponsor
#yiv6061782425ygrp-lc {font-family:Arial;}#yiv6061782425
#yiv6061782425ygrp-sponsor #yiv6061782425ygrp-lc #yiv6061782425hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6061782425
#yiv6061782425ygrp-sponsor #yiv6061782425ygrp-lc .yiv6061782425ad
{margin-bottom:10px;padding:0 0;}#yiv6061782425 #yiv6061782425actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6061782425
#yiv6061782425activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6061782425
#yiv6061782425activity span {font-weight:700;}#yiv6061782425
#yiv6061782425activity span:first-child
{text-transform:uppercase;}#yiv6061782425 #yiv6061782425activity span a
{color:#5085b6;text-decoration:none;}#yiv6061782425 #yiv6061782425activity span
span {color:#ff7900;}#yiv6061782425 #yiv6061782425activity span
.yiv6061782425underline {text-decoration:underline;}#yiv6061782425
.yiv6061782425attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6061782425 .yiv6061782425attach div a
{text-decoration:none;}#yiv6061782425 .yiv6061782425attach img
{border:none;padding-right:5px;}#yiv6061782425 .yiv6061782425attach label
{display:block;margin-bottom:5px;}#yiv6061782425 .yiv6061782425attach label a
{text-decoration:none;}#yiv6061782425 blockquote {margin:0 0 0
4px;}#yiv6061782425 .yiv6061782425bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6061782425
.yiv6061782425bold a {text-decoration:none;}#yiv6061782425 dd.yiv6061782425last
p a {font-family:Verdana;font-weight:700;}#yiv6061782425 dd.yiv6061782425last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6061782425
dd.yiv6061782425last p span.yiv6061782425yshortcuts
{margin-right:0;}#yiv6061782425 div.yiv6061782425attach-table div di
Re: [belajar-excel] Kolom Otomatis
Salam Rekan nang Agus,
Saya sudah lakukan pertanyaan pertama seperti yg di sarankan, namun hasilnya
menjadi kosong.
Pertanyaan kedua sebenarnya saya ingin membuat laporan, namun saya belum
mengetahui berapa tabel yang dibutuhkan.
Saya membutuhkan tabel yang fleksible, jika ditambahkan entri baru tabel itu
akan bertambah.
Saya lampirkan kembali Filenya.
Mohon pencerahannya dan terima kasih.
Salam.Hariyanto
Pada Kamis, 24 Mei 2018 06.35.40 GMT+8, NangAgus nanga...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Dear Hariyanto,
untuk pertanyaan:
Jika Kolom C32 diisi maka kolom jumlah otomatis turun kebawah ..
* Buatlah data tersebut menjadi tabel (blok B5:L31 >> tab Insert >> Table >> OK)
Pada Kolom C4 jika di isi dengan tulisan 25 Hari, maka jasil tidak berubah
* Bukankah hari kerja diletakkan di sheet Master Data F5? Jadi yang diubah
adalah pada sheet Masterdata F5. Sedangkan disheet Januari C3 cukup ditulis
formula: =harikerja.
Regard
NangAgus
On 5/23/2018 8:17 PM, depi Hariyanto depi.hari_ya...@yahoo.co.id
[belajar-excel] wrote:
Dear Rekan2 Master Excel,
Mohon Bantuan dan pencerahannya, file terlampir
Terima kasih sebelumnya,
Salam Hariyanto
#yiv8162687399 #yiv8162687399 -- #yiv8162687399ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8162687399
#yiv8162687399ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8162687399
#yiv8162687399ygrp-mkp #yiv8162687399hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8162687399 #yiv8162687399ygrp-mkp #yiv8162687399ads
{margin-bottom:10px;}#yiv8162687399 #yiv8162687399ygrp-mkp .yiv8162687399ad
{padding:0 0;}#yiv8162687399 #yiv8162687399ygrp-mkp .yiv8162687399ad p
{margin:0;}#yiv8162687399 #yiv8162687399ygrp-mkp .yiv8162687399ad a
{color:#ff;text-decoration:none;}#yiv8162687399 #yiv8162687399ygrp-sponsor
#yiv8162687399ygrp-lc {font-family:Arial;}#yiv8162687399
#yiv8162687399ygrp-sponsor #yiv8162687399ygrp-lc #yiv8162687399hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8162687399
#yiv8162687399ygrp-sponsor #yiv8162687399ygrp-lc .yiv8162687399ad
{margin-bottom:10px;padding:0 0;}#yiv8162687399 #yiv8162687399actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8162687399
#yiv8162687399activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8162687399
#yiv8162687399activity span {font-weight:700;}#yiv8162687399
#yiv8162687399activity span:first-child
{text-transform:uppercase;}#yiv8162687399 #yiv8162687399activity span a
{color:#5085b6;text-decoration:none;}#yiv8162687399 #yiv8162687399activity span
span {color:#ff7900;}#yiv8162687399 #yiv8162687399activity span
.yiv8162687399underline {text-decoration:underline;}#yiv8162687399
.yiv8162687399attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8162687399 .yiv8162687399attach div a
{text-decoration:none;}#yiv8162687399 .yiv8162687399attach img
{border:none;padding-right:5px;}#yiv8162687399 .yiv8162687399attach label
{display:block;margin-bottom:5px;}#yiv8162687399 .yiv8162687399attach label a
{text-decoration:none;}#yiv8162687399 blockquote {margin:0 0 0
4px;}#yiv8162687399 .yiv8162687399bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8162687399
.yiv8162687399bold a {text-decoration:none;}#yiv8162687399 dd.yiv8162687399last
p a {font-family:Verdana;font-weight:700;}#yiv8162687399 dd.yiv8162687399last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8162687399
dd.yiv8162687399last p span.yiv8162687399yshortcuts
{margin-right:0;}#yiv8162687399 div.yiv8162687399attach-table div div a
{text-decoration:none;}#yiv8162687399 div.yiv8162687399attach-table
{width:400px;}#yiv8162687399 div.yiv8162687399file-title a, #yiv8162687399
div.yiv8162687399file-title a:active, #yiv8162687399
div.yiv8162687399file-title a:hover, #yiv8162687399 div.yiv8162687399file-title
a:visited {text-decoration:none;}#yiv8162687399 div.yiv8162687399photo-title a,
#yiv8162687399 div.yiv8162687399photo-title a:active, #yiv8162687399
div.yiv8162687399photo-title a:hover, #yiv8162687399
div.yiv8162687399photo-title a:visited {text-decoration:none;}#yiv8162687399
div#yiv8162687399ygrp-mlmsg #yiv8162687399ygrp-msg p a
span.yiv8162687399yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8162687399
.yiv8162687399green {color:#628c2a;}#yiv8162687399 .yiv8162687399MsoNormal
{margin:0 0 0 0;}#yiv8162687399 o {font-size:0;}#yiv8162687399
#yiv8162687399photos div {float:left;width:72px;}#yiv8162687399
#yiv8162687399photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv8162687399
#yiv8162687399photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8162687399
#yiv8162687399rec
Re: [belajar-excel] Hitung Insentive Otomatis
Terima kasih rekan Nang Agus atas pencerahannya.
SalamHariyanto
Pada Selasa, 22 Mei 2018 21.25.59 GMT+8, NangAgus nanga...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Mohon maaf saya tidak tahu cara menghitungnya karena tidak ada contoh.
Silahkan dibuka lampiran!
Regard
On 5/22/2018 4:48 AM, depi Hariyanto depi.hari_ya...@yahoo.co.id
[belajar-excel] wrote:
Kepada rekan-rekan master excel,
Mohon bantuannya cara perhitungan insentive secara otomatis berdasarkan dara
pada sheet master data, pertanyaan dan contoh terlampir.
Terima kasih sebelumnya atas bantuan dan pencerahannya.
Salam Hariyanto
#yiv1656201290 #yiv1656201290 -- #yiv1656201290ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1656201290
#yiv1656201290ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1656201290
#yiv1656201290ygrp-mkp #yiv1656201290hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1656201290 #yiv1656201290ygrp-mkp #yiv1656201290ads
{margin-bottom:10px;}#yiv1656201290 #yiv1656201290ygrp-mkp .yiv1656201290ad
{padding:0 0;}#yiv1656201290 #yiv1656201290ygrp-mkp .yiv1656201290ad p
{margin:0;}#yiv1656201290 #yiv1656201290ygrp-mkp .yiv1656201290ad a
{color:#ff;text-decoration:none;}#yiv1656201290 #yiv1656201290ygrp-sponsor
#yiv1656201290ygrp-lc {font-family:Arial;}#yiv1656201290
#yiv1656201290ygrp-sponsor #yiv1656201290ygrp-lc #yiv1656201290hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1656201290
#yiv1656201290ygrp-sponsor #yiv1656201290ygrp-lc .yiv1656201290ad
{margin-bottom:10px;padding:0 0;}#yiv1656201290 #yiv1656201290actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1656201290
#yiv1656201290activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1656201290
#yiv1656201290activity span {font-weight:700;}#yiv1656201290
#yiv1656201290activity span:first-child
{text-transform:uppercase;}#yiv1656201290 #yiv1656201290activity span a
{color:#5085b6;text-decoration:none;}#yiv1656201290 #yiv1656201290activity span
span {color:#ff7900;}#yiv1656201290 #yiv1656201290activity span
.yiv1656201290underline {text-decoration:underline;}#yiv1656201290
.yiv1656201290attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1656201290 .yiv1656201290attach div a
{text-decoration:none;}#yiv1656201290 .yiv1656201290attach img
{border:none;padding-right:5px;}#yiv1656201290 .yiv1656201290attach label
{display:block;margin-bottom:5px;}#yiv1656201290 .yiv1656201290attach label a
{text-decoration:none;}#yiv1656201290 blockquote {margin:0 0 0
4px;}#yiv1656201290 .yiv1656201290bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1656201290
.yiv1656201290bold a {text-decoration:none;}#yiv1656201290 dd.yiv1656201290last
p a {font-family:Verdana;font-weight:700;}#yiv1656201290 dd.yiv1656201290last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1656201290
dd.yiv1656201290last p span.yiv1656201290yshortcuts
{margin-right:0;}#yiv1656201290 div.yiv1656201290attach-table div div a
{text-decoration:none;}#yiv1656201290 div.yiv1656201290attach-table
{width:400px;}#yiv1656201290 div.yiv1656201290file-title a, #yiv1656201290
div.yiv1656201290file-title a:active, #yiv1656201290
div.yiv1656201290file-title a:hover, #yiv1656201290 div.yiv1656201290file-title
a:visited {text-decoration:none;}#yiv1656201290 div.yiv1656201290photo-title a,
#yiv1656201290 div.yiv1656201290photo-title a:active, #yiv1656201290
div.yiv1656201290photo-title a:hover, #yiv1656201290
div.yiv1656201290photo-title a:visited {text-decoration:none;}#yiv1656201290
div#yiv1656201290ygrp-mlmsg #yiv1656201290ygrp-msg p a
span.yiv1656201290yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1656201290
.yiv1656201290green {color:#628c2a;}#yiv1656201290 .yiv1656201290MsoNormal
{margin:0 0 0 0;}#yiv1656201290 o {font-size:0;}#yiv1656201290
#yiv1656201290photos div {float:left;width:72px;}#yiv1656201290
#yiv1656201290photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1656201290
#yiv1656201290photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1656201290
#yiv1656201290reco-category {font-size:77%;}#yiv1656201290
#yiv1656201290reco-desc {font-size:77%;}#yiv1656201290 .yiv1656201290replbq
{margin:4px;}#yiv1656201290 #yiv1656201290ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1656201290 #yiv1656201290ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1656201290
#yiv1656201290ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1656201290
#yiv1656201290ygrp-mlmsg select, #yiv1656201290 input, #yiv1656201290 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1656201290
#yiv1656201290ygrp-mlm
[belajar-excel] Hitung Insentive Otomatis [1 Attachment]
Kepada rekan-rekan master excel, Mohon bantuannya cara perhitungan insentive secara otomatis berdasarkan dara pada sheet master data, pertanyaan dan contoh terlampir. Terima kasih sebelumnya atas bantuan dan pencerahannya. SalamHariyanto Master Data Insentif.xlsx Description: MS-Excel 2007 spreadsheet
Re: [belajar-excel] Perhitungan Insentive
Salam rekan - rekan belajar excel semua,
Ada sedikit ketinggalan dari pertanyaan saya sebelumnya, mohon bantuannya
kembali, pertanyaan dan file terlampir.
Terima kasihHariyanto
Pada Minggu, 20 Mei 2018 14.37.45 GMT+8, depi Hariyanto
depi.hari_ya...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>
menulis:
Salam Rekan Semua,
Ada sedikit ketinggalan dari pertanyaan saya sebelumnya, mohon bantuannya
kembali, file terlampir.
Terima kasihHariyanto
Pada Sabtu, 19 Mei 2018 00.38.43 GMT+8, NangAgus nanga...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Salam
Dear Hariyanto
Coba di J6 gunakan rumus :
=D6-target*harikerja
kemudian format custom: #;-;#
Regard
NangAgus
On 5/18/2018 2:10 PM, depi Hariyanto depi.hari_ya...@yahoo.co...id
[belajar-excel] wrote:
Salam,
Mohon bantuannya formula perhitungan kelebihan target secara otomatis, file
terlampir.
Terima kasih sebelumnya.
Salam,
Dephar.
#yiv7305535163 #yiv7305535163 -- #yiv7305535163ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7305535163
#yiv7305535163ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7305535163
#yiv7305535163ygrp-mkp #yiv7305535163hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7305535163 #yiv7305535163ygrp-mkp #yiv7305535163ads
{margin-bottom:10px;}#yiv7305535163 #yiv7305535163ygrp-mkp .yiv7305535163ad
{padding:0 0;}#yiv7305535163 #yiv7305535163ygrp-mkp .yiv7305535163ad p
{margin:0;}#yiv7305535163 #yiv7305535163ygrp-mkp .yiv7305535163ad a
{color:#ff;text-decoration:none;}#yiv7305535163 #yiv7305535163ygrp-sponsor
#yiv7305535163ygrp-lc {font-family:Arial;}#yiv7305535163
#yiv7305535163ygrp-sponsor #yiv7305535163ygrp-lc #yiv7305535163hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7305535163
#yiv7305535163ygrp-sponsor #yiv7305535163ygrp-lc .yiv7305535163ad
{margin-bottom:10px;padding:0 0;}#yiv7305535163 #yiv7305535163actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7305535163
#yiv7305535163activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7305535163
#yiv7305535163activity span {font-weight:700;}#yiv7305535163
#yiv7305535163activity span:first-child
{text-transform:uppercase;}#yiv7305535163 #yiv7305535163activity span a
{color:#5085b6;text-decoration:none;}#yiv7305535163 #yiv7305535163activity span
span {color:#ff7900;}#yiv7305535163 #yiv7305535163activity span
.yiv7305535163underline {text-decoration:underline;}#yiv7305535163
.yiv7305535163attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7305535163 .yiv7305535163attach div a
{text-decoration:none;}#yiv7305535163 .yiv7305535163attach img
{border:none;padding-right:5px;}#yiv7305535163 .yiv7305535163attach label
{display:block;margin-bottom:5px;}#yiv7305535163 .yiv7305535163attach label a
{text-decoration:none;}#yiv7305535163 blockquote {margin:0 0 0
4px;}#yiv7305535163 .yiv7305535163bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7305535163
.yiv7305535163bold a {text-decoration:none;}#yiv7305535163 dd.yiv7305535163last
p a {font-family:Verdana;font-weight:700;}#yiv7305535163 dd.yiv7305535163last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7305535163
dd.yiv7305535163last p span.yiv7305535163yshortcuts
{margin-right:0;}#yiv7305535163 div.yiv7305535163attach-table div div a
{text-decoration:none;}#yiv7305535163 div.yiv7305535163attach-table
{width:400px;}#yiv7305535163 div.yiv7305535163file-title a, #yiv7305535163
div.yiv7305535163file-title a:active, #yiv7305535163
div.yiv7305535163file-title a:hover, #yiv7305535163 div.yiv7305535163file-title
a:visited {text-decoration:none;}#yiv7305535163 div.yiv7305535163photo-title a,
#yiv7305535163 div.yiv7305535163photo-title a:active, #yiv7305535163
div.yiv7305535163photo-title a:hover, #yiv7305535163
div.yiv7305535163photo-title a:visited {text-decoration:none;}#yiv7305535163
div#yiv7305535163ygrp-mlmsg #yiv7305535163ygrp-msg p a
span.yiv7305535163yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7305535163
.yiv7305535163green {color:#628c2a;}#yiv7305535163 ...yiv7305535163MsoNormal
{margin:0 0 0 0;}#yiv7305535163 o {font-size:0;}#yiv7305535163
#yiv7305535163photos div {float:left;width:72px;}#yiv7305535163
#yiv7305535163photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv7305535163
#yiv7305535163photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7305535163
#yiv7305535163reco-category {font-size:77%;}#yiv7305535163
#yiv7305535163reco-desc {font-size:77%;}#yiv7305535163 .yiv7305535163replbq
{margin:4px;}#yiv7305535163 #yiv7305535163ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7305535163 #yiv7305535163ygrp-mlmsg
{fo
Re: [belajar-excel] Perhitungan Insentive
Salam Rekan Semua,
Ada sedikit ketinggalan dari pertanyaan saya sebelumnya, mohon bantuannya
kembali, file terlampir.
Terima kasihHariyanto
Pada Sabtu, 19 Mei 2018 00.38.43 GMT+8, NangAgus nanga...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Salam
Dear Hariyanto
Coba di J6 gunakan rumus :
=D6-target*harikerja
kemudian format custom: #;-;#
Regard
NangAgus
On 5/18/2018 2:10 PM, depi Hariyanto depi.hari_ya...@yahoo.co.id
[belajar-excel] wrote:
Salam,
Mohon bantuannya formula perhitungan kelebihan target secara otomatis, file
terlampir.
Terima kasih sebelumnya.
Salam,
Dephar.
#yiv2229873038 #yiv2229873038 -- #yiv2229873038ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2229873038
#yiv2229873038ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2229873038
#yiv2229873038ygrp-mkp #yiv2229873038hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2229873038 #yiv2229873038ygrp-mkp #yiv2229873038ads
{margin-bottom:10px;}#yiv2229873038 #yiv2229873038ygrp-mkp .yiv2229873038ad
{padding:0 0;}#yiv2229873038 #yiv2229873038ygrp-mkp .yiv2229873038ad p
{margin:0;}#yiv2229873038 #yiv2229873038ygrp-mkp .yiv2229873038ad a
{color:#ff;text-decoration:none;}#yiv2229873038 #yiv2229873038ygrp-sponsor
#yiv2229873038ygrp-lc {font-family:Arial;}#yiv2229873038
#yiv2229873038ygrp-sponsor #yiv2229873038ygrp-lc #yiv2229873038hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2229873038
#yiv2229873038ygrp-sponsor #yiv2229873038ygrp-lc .yiv2229873038ad
{margin-bottom:10px;padding:0 0;}#yiv2229873038 #yiv2229873038actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2229873038
#yiv2229873038activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2229873038
#yiv2229873038activity span {font-weight:700;}#yiv2229873038
#yiv2229873038activity span:first-child
{text-transform:uppercase;}#yiv2229873038 #yiv2229873038activity span a
{color:#5085b6;text-decoration:none;}#yiv2229873038 #yiv2229873038activity span
span {color:#ff7900;}#yiv2229873038 #yiv2229873038activity span
.yiv2229873038underline {text-decoration:underline;}#yiv2229873038
.yiv2229873038attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2229873038 ...yiv2229873038attach div a
{text-decoration:none;}#yiv2229873038 .yiv2229873038attach img
{border:none;padding-right:5px;}#yiv2229873038 .yiv2229873038attach label
{display:block;margin-bottom:5px;}#yiv2229873038 .yiv2229873038attach label a
{text-decoration:none;}#yiv2229873038 blockquote {margin:0 0 0
4px;}#yiv2229873038 .yiv2229873038bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2229873038
.yiv2229873038bold a {text-decoration:none;}#yiv2229873038 dd.yiv2229873038last
p a {font-family:Verdana;font-weight:700;}#yiv2229873038 dd.yiv2229873038last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2229873038
dd.yiv2229873038last p span.yiv2229873038yshortcuts
{margin-right:0;}#yiv2229873038 div.yiv2229873038attach-table div div a
{text-decoration:none;}#yiv2229873038 div.yiv2229873038attach-table
{width:400px;}#yiv2229873038 div.yiv2229873038file-title a, #yiv2229873038
div.yiv2229873038file-title a:active, #yiv2229873038
div.yiv2229873038file-title a:hover, #yiv2229873038 div.yiv2229873038file-title
a:visited {text-decoration:none;}#yiv2229873038 div.yiv2229873038photo-title a,
#yiv2229873038 div.yiv2229873038photo-title a:active, #yiv2229873038
div.yiv2229873038photo-title a:hover, #yiv2229873038
div.yiv2229873038photo-title a:visited {text-decoration:none;}#yiv2229873038
div#yiv2229873038ygrp-mlmsg #yiv2229873038ygrp-msg p a
span.yiv2229873038yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2229873038
.yiv2229873038green {color:#628c2a;}#yiv2229873038 .yiv2229873038MsoNormal
{margin:0 0 0 0;}#yiv2229873038 o {font-size:0;}#yiv2229873038
#yiv2229873038photos div {float:left;width:72px;}#yiv2229873038
#yiv2229873038photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2229873038
#yiv2229873038photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2229873038
#yiv2229873038reco-category {font-size:77%;}#yiv2229873038
#yiv2229873038reco-desc {font-size:77%;}#yiv2229873038 .yiv2229873038replbq
{margin:4px;}#yiv2229873038 #yiv2229873038ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2229873038 #yiv2229873038ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2229873038
#yiv2229873038ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2229873038
#yiv2229873038ygrp-mlmsg select, #yiv2229873038 input, #yiv2229873038 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2229873038
#yiv2229873038ygrp-mlmsg pre, #yiv2229
[belajar-excel] Perhitungan Insentive [1 Attachment]
Salam, Mohon bantuannya formula perhitungan kelebihan target secara otomatis, file terlampir. Terima kasih sebelumnya. Salam, Dephar. Perhitungan Insentive.xlsx Description: MS-Excel 2007 spreadsheet
Bls: [belajar-excel] Jumlah beda sheet
dear toby.tambahan formulanya seperti apa ya.? sy coba belum nemu.
regards.
Pada Kamis, 10 Maret 2016 11:18, "Toby kenzo tobyke...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Depi,
Coba tambahkan formula DateValue sebelum formula Right dan Left.
TerimaKasih
Pada Kamis, 10 Maret 2016 10:20, "depi Hariyanto
depi.hari_ya...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:
Salam Master Excel,Mohon bantuan sedikit kendala pada formula, untuk
pertannyaan terlampir.
Salam,DepHar
#yiv9470807172 #yiv9470807172 -- #yiv9470807172ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9470807172
#yiv9470807172ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9470807172
#yiv9470807172ygrp-mkp #yiv9470807172hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9470807172 #yiv9470807172ygrp-mkp #yiv9470807172ads
{margin-bottom:10px;}#yiv9470807172 #yiv9470807172ygrp-mkp .yiv9470807172ad
{padding:0 0;}#yiv9470807172 #yiv9470807172ygrp-mkp .yiv9470807172ad p
{margin:0;}#yiv9470807172 #yiv9470807172ygrp-mkp .yiv9470807172ad a
{color:#ff;text-decoration:none;}#yiv9470807172 #yiv9470807172ygrp-sponsor
#yiv9470807172ygrp-lc {font-family:Arial;}#yiv9470807172
#yiv9470807172ygrp-sponsor #yiv9470807172ygrp-lc #yiv9470807172hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9470807172
#yiv9470807172ygrp-sponsor #yiv9470807172ygrp-lc .yiv9470807172ad
{margin-bottom:10px;padding:0 0;}#yiv9470807172 #yiv9470807172actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9470807172
#yiv9470807172activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9470807172
#yiv9470807172activity span {font-weight:700;}#yiv9470807172
#yiv9470807172activity span:first-child
{text-transform:uppercase;}#yiv9470807172 #yiv9470807172activity span a
{color:#5085b6;text-decoration:none;}#yiv9470807172 #yiv9470807172activity span
span {color:#ff7900;}#yiv9470807172 #yiv9470807172activity span
.yiv9470807172underline {text-decoration:underline;}#yiv9470807172
.yiv9470807172attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9470807172 .yiv9470807172attach div a
{text-decoration:none;}#yiv9470807172 .yiv9470807172attach img
{border:none;padding-right:5px;}#yiv9470807172 .yiv9470807172attach label
{display:block;margin-bottom:5px;}#yiv9470807172 .yiv9470807172attach label a
{text-decoration:none;}#yiv9470807172 blockquote {margin:0 0 0
4px;}#yiv9470807172 .yiv9470807172bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9470807172
.yiv9470807172bold a {text-decoration:none;}#yiv9470807172 dd.yiv9470807172last
p a {font-family:Verdana;font-weight:700;}#yiv9470807172 dd.yiv9470807172last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9470807172
dd.yiv9470807172last p span.yiv9470807172yshortcuts
{margin-right:0;}#yiv9470807172 div.yiv9470807172attach-table div div a
{text-decoration:none;}#yiv9470807172 div.yiv9470807172attach-table
{width:400px;}#yiv9470807172 div.yiv9470807172file-title a, #yiv9470807172
div.yiv9470807172file-title a:active, #yiv9470807172
div.yiv9470807172file-title a:hover, #yiv9470807172 div.yiv9470807172file-title
a:visited {text-decoration:none;}#yiv9470807172 div.yiv9470807172photo-title a,
#yiv9470807172 div.yiv9470807172photo-title a:active, #yiv9470807172
div.yiv9470807172photo-title a:hover, #yiv9470807172
div.yiv9470807172photo-title a:visited {text-decoration:none;}#yiv9470807172
div#yiv9470807172ygrp-mlmsg #yiv9470807172ygrp-msg p a
span.yiv9470807172yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9470807172
.yiv9470807172green {color:#628c2a;}#yiv9470807172 .yiv9470807172MsoNormal
{margin:0 0 0 0;}#yiv9470807172 o {font-size:0;}#yiv9470807172
#yiv9470807172photos div {float:left;width:72px;}#yiv9470807172
#yiv9470807172photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv9470807172
#yiv9470807172photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9470807172
#yiv9470807172reco-category {font-size:77%;}#yiv9470807172
#yiv9470807172reco-desc {font-size:77%;}#yiv9470807172 .yiv9470807172replbq
{margin:4px;}#yiv9470807172 #yiv9470807172ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9470807172 #yiv9470807172ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9470807172
#yiv9470807172ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9470807172
#yiv9470807172ygrp-mlmsg select, #yiv9470807172 input, #yiv9470807172 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9470807172
#yiv9470807172ygrp-mlmsg pre, #yiv9470807172 code {font:115%
monospace;}#yiv9470807172 #yiv9470
Bls: [belajar-excel] Jumlah pada Sheet Lain [2 Attachments]
Dear All Master Excel,Saya sudah mencoba kedua cara yang di berikan, namun jika
saya mengganti data pada sheet A dan B, sheet Menu pada kolom D2 dengan data
dan tanggal yang update penjumlahan pada sheet menu pada kolom D kosong dan
tidak terjumlah.
Dekalian minta cara bagai mana merubah format tanggal 01/31/2016 menjadi
01-31-2016 sekaligus.?
Terima kasih sebelumnya.
Salam,
Pada Kamis, 4 Februari 2016 9:00, "Nang Agus nanga...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Coba gunakan formula :
=SUMPRODUCT((A!E5:E78<=RIGHT(D2;9)*1)*(A!E5:E78>=LEFT(D2;8)*1)*(ISTEXT(A!A5:A78)))
2016-02-03 8:54 GMT+07:00 depi Hariyanto depi.hari_ya...@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
Kepada Rekan-rekan Master Excel,
Mohon bantuan dan solusinya, bagai mana cara menjumlahkan jika transaksi pada
tanggal digabungkan.? terlampir data excel.
Terima Kasih atas bantuannya,
Salam,DepHar
#yiv5390329203 #yiv5390329203 -- #yiv5390329203ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5390329203
#yiv5390329203ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5390329203
#yiv5390329203ygrp-mkp #yiv5390329203hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5390329203 #yiv5390329203ygrp-mkp #yiv5390329203ads
{margin-bottom:10px;}#yiv5390329203 #yiv5390329203ygrp-mkp .yiv5390329203ad
{padding:0 0;}#yiv5390329203 #yiv5390329203ygrp-mkp .yiv5390329203ad p
{margin:0;}#yiv5390329203 #yiv5390329203ygrp-mkp .yiv5390329203ad a
{color:#ff;text-decoration:none;}#yiv5390329203 #yiv5390329203ygrp-sponsor
#yiv5390329203ygrp-lc {font-family:Arial;}#yiv5390329203
#yiv5390329203ygrp-sponsor #yiv5390329203ygrp-lc #yiv5390329203hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5390329203
#yiv5390329203ygrp-sponsor #yiv5390329203ygrp-lc .yiv5390329203ad
{margin-bottom:10px;padding:0 0;}#yiv5390329203 #yiv5390329203actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5390329203
#yiv5390329203activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5390329203
#yiv5390329203activity span {font-weight:700;}#yiv5390329203
#yiv5390329203activity span:first-child
{text-transform:uppercase;}#yiv5390329203 #yiv5390329203activity span a
{color:#5085b6;text-decoration:none;}#yiv5390329203 #yiv5390329203activity span
span {color:#ff7900;}#yiv5390329203 #yiv5390329203activity span
.yiv5390329203underline {text-decoration:underline;}#yiv5390329203
.yiv5390329203attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5390329203 .yiv5390329203attach div a
{text-decoration:none;}#yiv5390329203 .yiv5390329203attach img
{border:none;padding-right:5px;}#yiv5390329203 .yiv5390329203attach label
{display:block;margin-bottom:5px;}#yiv5390329203 .yiv5390329203attach label a
{text-decoration:none;}#yiv5390329203 blockquote {margin:0 0 0
4px;}#yiv5390329203 .yiv5390329203bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5390329203
.yiv5390329203bold a {text-decoration:none;}#yiv5390329203 dd.yiv5390329203last
p a {font-family:Verdana;font-weight:700;}#yiv5390329203 dd.yiv5390329203last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5390329203
dd.yiv5390329203last p span.yiv5390329203yshortcuts
{margin-right:0;}#yiv5390329203 div.yiv5390329203attach-table div div a
{text-decoration:none;}#yiv5390329203 div.yiv5390329203attach-table
{width:400px;}#yiv5390329203 div.yiv5390329203file-title a, #yiv5390329203
div.yiv5390329203file-title a:active, #yiv5390329203
div.yiv5390329203file-title a:hover, #yiv5390329203 div.yiv5390329203file-title
a:visited {text-decoration:none;}#yiv5390329203 div.yiv5390329203photo-title a,
#yiv5390329203 div.yiv5390329203photo-title a:active, #yiv5390329203
div.yiv5390329203photo-title a:hover, #yiv5390329203
div.yiv5390329203photo-title a:visited {text-decoration:none;}#yiv5390329203
div#yiv5390329203ygrp-mlmsg #yiv5390329203ygrp-msg p a
span.yiv5390329203yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5390329203
.yiv5390329203green {color:#628c2a;}#yiv5390329203 .yiv5390329203MsoNormal
{margin:0 0 0 0;}#yiv5390329203 o {font-size:0;}#yiv5390329203
#yiv5390329203photos div {float:left;width:72px;}#yiv5390329203
#yiv5390329203photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv5390329203
#yiv5390329203photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5390329203
#yiv5390329203reco-category {font-size:77%;}#yiv5390329203
#yiv5390329203reco-desc {font-size:77%;}#yiv5390329203 .yiv5390329203replbq
{margin:4px;}#yiv5390329203 #yiv5390329203ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5390329203 #yiv5390329203ygrp-mlmsg
{font
[belajar-excel] formula penambahan estimasi satu hari [1 Attachment]
Kepada Master Excel, bagai mana cara menambahkan estimasi satu hari dengan menggunakan rumus formula, file terlampir. mohon bantuan para master excel sekalian dan terima kasih sebelumnnya. salamdepi Tambah Estimasi 1 Hari.xlsx Description: MS-Excel 2007 spreadsheet
Bls: [belajar-excel] Data Terpisah
dear mr bagus, saya sudah coba tapi tidak bisa. tks. Pada Selasa, 28 Oktober 2014 15:46, 'Bagus' ba...@kingjim.co.id [belajar-excel] belajar-excel@yahoogroups.com menulis: Pak Depi; Coba begini, Array formula ya: =IFERROR(INDEX(C$6:C$12,SMALL(IF($E$6:$E$12$Q$6,ROW($C$6:$C$12)-ROW($C$5)),ROW(1:1))),) Akhiri dengan menekan tiga tombol (Ctrl+Shift+Enter) Copas kekanan dan kebawah Wassalam ~ Bagus ~ - Original Message - From: depi Hariyanto depi.hari_ya...@yahoo.co.id [belajar-excel] To: belajar-excel@yahoogroups.com Sent: Tuesday, October 28, 2014 2:03 PM Subject: [belajar-excel] Data Terpisah [1 Attachment] Kepada Master Excel, Mohon bantuannya untuk data terlampir, atas bantuannya saya ucapkan banyak terima kasih. salam Dep_Har
[belajar-excel] Pembulatan Keatas [1 Attachment]
Kepada Master Excel, Mohon Bantuannya cara rumus formula untuk pembulatan keatas, File terlampir. Atas bantuannya saya ucapkan terima kasih. Salam Hormat Saya, Depi Pembulatan Keatas.xlsx Description: MS-Excel 2007 spreadsheet
