[belajar-excel] Digest Number 4683

Milis Belajar Microsoft Excel Group

4 Messages

Digest #4683

1a

Bls: [belajar-excel] Re: formula pph 21 gross up by "odong nando"

2a

Sarapan siang by "hendrik karnadi" hendrikkarnadi

2b

Re: Sarapan siang [1 Attachment] by "Agus"

3

Xcelsius Multiple Criteria by idz.iman

Messages

1a

Bls: [belajar-excel] Re: formula pph 21 gross up

Mon Jan 7, 2019 12:26 am (PST) . Posted by:

"odong nando"

ini lapirannya ga ada gan....? br,

odong nando

Dari: "y.roni35@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Jumat, 4 Januari 2019 18:44
Judul: [belajar-excel] Re: formula pph 21 gross up

  Dear All,

Berikut formula PPH 21 Net Mungkin bisa membantu.Untuk Gross Up tinggal ditambahkan nilai yg akan di gross up.Terimakasih

Regards,Roni #yiv6661868760 #yiv6661868760 -- #yiv6661868760ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6661868760 #yiv6661868760ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6661868760 #yiv6661868760ygrp-mkp #yiv6661868760hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6661868760 #yiv6661868760ygrp-mkp #yiv6661868760ads {margin-bottom:10px;}#yiv6661868760 #yiv6661868760ygrp-mkp .yiv6661868760ad {padding:0 0;}#yiv6661868760 #yiv6661868760ygrp-mkp .yiv6661868760ad p {margin:0;}#yiv6661868760 #yiv6661868760ygrp-mkp .yiv6661868760ad a {color:#0000ff;text-decoration:none;}#yiv6661868760 #yiv6661868760ygrp-sponsor #yiv6661868760ygrp-lc {font-family:Arial;}#yiv6661868760 #yiv6661868760ygrp-sponsor #yiv6661868760ygrp-lc #yiv6661868760hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6661868760 #yiv6661868760ygrp-sponsor #yiv6661868760ygrp-lc .yiv6661868760ad {margin-bottom:10px;padding:0 0;}#yiv6661868760 #yiv6661868760actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6661868760 #yiv6661868760activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6661868760 #yiv6661868760activity span {font-weight:700;}#yiv6661868760 #yiv6661868760activity span:first-child {text-transform:uppercase;}#yiv6661868760 #yiv6661868760activity span a {color:#5085b6;text-decoration:none;}#yiv6661868760 #yiv6661868760activity span span {color:#ff7900;}#yiv6661868760 #yiv6661868760activity span .yiv6661868760underline {text-decoration:underline;}#yiv6661868760 .yiv6661868760attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6661868760 .yiv6661868760attach div a {text-decoration:none;}#yiv6661868760 .yiv6661868760attach img {border:none;padding-right:5px;}#yiv6661868760 .yiv6661868760attach label {display:block;margin-bottom:5px;}#yiv6661868760 .yiv6661868760attach label a {text-decoration:none;}#yiv6661868760 blockquote {margin:0 0 0 4px;}#yiv6661868760 .yiv6661868760bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6661868760 .yiv6661868760bold a {text-decoration:none;}#yiv6661868760 dd.yiv6661868760last p a {font-family:Verdana;font-weight:700;}#yiv6661868760 dd.yiv6661868760last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6661868760 dd.yiv6661868760last p span.yiv6661868760yshortcuts {margin-right:0;}#yiv6661868760 div.yiv6661868760attach-table div div a {text-decoration:none;}#yiv6661868760 div.yiv6661868760attach-table {width:400px;}#yiv6661868760 div.yiv6661868760file-title a, #yiv6661868760 div.yiv6661868760file-title a:active, #yiv6661868760 div.yiv6661868760file-title a:hover, #yiv6661868760 div.yiv6661868760file-title a:visited {text-decoration:none;}#yiv6661868760 div.yiv6661868760photo-title a, #yiv6661868760 div.yiv6661868760photo-title a:active, #yiv6661868760 div.yiv6661868760photo-title a:hover, #yiv6661868760 div.yiv6661868760photo-title a:visited {text-decoration:none;}#yiv6661868760 div#yiv6661868760ygrp-mlmsg #yiv6661868760ygrp-msg p a span..yiv6661868760yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6661868760 .yiv6661868760green {color:#628c2a;}#yiv6661868760 .yiv6661868760MsoNormal {margin:0 0 0 0;}#yiv6661868760 o {font-size:0;}#yiv6661868760 #yiv6661868760photos div {float:left;width:72px;}#yiv6661868760 #yiv6661868760photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6661868760 #yiv6661868760photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6661868760 #yiv6661868760reco-category {font-size:77%;}#yiv6661868760 #yiv6661868760reco-desc {font-size:77%;}#yiv6661868760 .yiv6661868760replbq {margin:4px;}#yiv6661868760 #yiv6661868760ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6661868760 #yiv6661868760ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6661868760 #yiv6661868760ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6661868760 #yiv6661868760ygrp-mlmsg select, #yiv6661868760 input, #yiv6661868760 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6661868760 #yiv6661868760ygrp-mlmsg pre, #yiv6661868760 code {font:115% monospace;}#yiv6661868760 #yiv6661868760ygrp-mlmsg * {line-height:1.22em;}#yiv6661868760 #yiv6661868760ygrp-mlmsg #yiv6661868760logo {padding-bottom:10px;}#yiv6661868760 #yiv6661868760ygrp-msg p a {font-family:Verdana;}#yiv6661868760 #yiv6661868760ygrp-msg p#yiv6661868760attach-count span {color:#1E66AE;font-weight:700;}#yiv6661868760 #yiv6661868760ygrp-reco #yiv6661868760reco-head {color:#ff7900;font-weight:700;}#yiv6661868760 #yiv6661868760ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6661868760 #yiv6661868760ygrp-sponsor #yiv6661868760ov li a {font-size:130%;text-decoration:none;}#yiv6661868760 #yiv6661868760ygrp-sponsor #yiv6661868760ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6661868760 #yiv6661868760ygrp-sponsor #yiv6661868760ov ul {margin:0;padding:0 0 0 8px;}#yiv6661868760 #yiv6661868760ygrp-text {font-family:Georgia;}#yiv6661868760 #yiv6661868760ygrp-text p {margin:0 0 1em 0;}#yiv6661868760 #yiv6661868760ygrp-text tt {font-size:120%;}#yiv6661868760 #yiv6661868760ygrp-vital ul li:last-child {border-right:none !important;}#yiv6661868760

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

2a

Sarapan siang

Mon Jan 7, 2019 1:17 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sekilas info...menjelaskan yang sudah jelas (bagi yang sudah tau).
Dear Be Excel,Baru saja saya ditanya oleh temen kantor mengapa Fungsi SubTotal dengan bilangan 9 (Subtotal(9,range)) hslnya sama dengan bilangan 109 ((Subtotal(109,range)) .
Ternyata,- Jika menggunakan FIlter hasilnya akan sama tetapi....- Jika menggunakan Hide (baris) maka hasilnya akan berbeda.
File contoh terlampir.
Salam,HK

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Sarapan siang [1 Attachment]

Mon Jan 7, 2019 6:29 am (PST) . Posted by:

"Agus"

Maaf Pak Hendrik, Melengkapi yang sudah jelas:
Menurut Helepnya Excel, 109 itu mengabaikan cel tersembunyi:
Salam
NangAgus
On 1/7/2019 16:17, hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] wrote:
> /
> /
> /
> /
> /
> /
> /
> /
> /
> /
> /Sekilas info...menjelaskan yang sudah jelas (bagi yang sudah tau)./
>
> Dear Be Excel,
> Baru saja saya ditanya oleh temen kantor mengapa Fungsi SubTotal
> dengan bilangan *9* (Subtotal(*9*,range)) hslnya sama dengan bilangan
> *109* ((Subtotal(*10**9*,range)) .
>
> Ternyata,
> - Jika menggunakan FIlter hasilnya akan sama tetapi....
> - Jika menggunakan Hide (baris) maka hasilnya akan berbeda.
>
> File contoh terlampir.
>
> Salam,
> HK
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3

Xcelsius Multiple Criteria

Mon Jan 7, 2019 7:20 pm (PST) . Posted by:

idz.iman

Assalammualaikum warahamatullah wabarakatuh,


mohon bantuannya, saya lagi buat dashboard di program Xcelsius.
Xcelsius ini banyak sekali tidak support dengan rumus2.


nah saya ada contoh multiple criteria yang biasanya saya pakai SUMPRODUCT ataupun SUMIFS, sayangnya untuk Xcelsius dia tidak support, saya mau tanya apakah ada logic lain yang bisa dibaca/support oleh Xcelsius?


salam

Iman

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use