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]
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] 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
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7305535163
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] 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, #yiv2229873038 code {font:115%
monospace;}#yiv2
Re: [belajar-excel] Perhitungan Insentive
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. Copy of Perhitungan Insentive.xlsx Description: MS-Excel 2007 spreadsheet
