Minggu, 21 Desember 2014

[belajar-excel] Digest Number 3234

2 Messages

Digest #3234
1a
Re: Bls: [belajar-excel] input ppn masukan by "hendrik karnadi" hendrikkarnadi
2a
Re: input ppn masukan [1 Attachment] by "Mr. Kid" nmkid.family@ymail.com

Messages

Sat Dec 20, 2014 6:40 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Odong,Formulanya bisa diperpanjang... seperti ini :=IF(AND(K2>=$C$2,K2<=$D$2),$E$2,IF(AND(K2>=$C$3,K2<=$D$3),$E$3,IF(AND(K2>=$C$4,K2<=$D$4),$E$4,IF(AND(K2>=$C$5,K2<=$D$5),$E$5,IF(AND(K2>=$C$6,K2<=$D$6),$E$6,IF(AND(K2>=$C$7,K2<=$D$7),$E$7,IF(AND(K2>=$C$8,K2<=$D$8),$E$8,IF(AND(K2>=$C$9,K2<=$D$9),$E$9,IF(AND(K2>=$C$10,K2<=$D$10),$E$10)))))))))
dstnya, kemudian dicopy ke bawah.
Excelnya musti 2007 ke atas, kalau 2003 max IF cuma 7 lapis.
Contoh dalam file terlampir (re_input PPN Masukan (R).xlsm) adalah dengan Excel 2010.
Pertanyaannya:Dalam 1 tahun berapa banyak faktur pajak (berapa baris) yang harus kita buat?
Salam,HK

From: "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, 18 December 2014, 19:09
Subject: Bls: [belajar-excel] input ppn masukan

  senang sekali bisa langsung ada tanggapan oleh pak HK,tp cara yang p' HK berikan masih berkendala bila ada penambahan jatah no dari kpp pak.karena jatah no tersebut akan terus bertambah selama perusahaan masih ada transaksi...mohon untuk pencerahan lebih lanjut.
 thx,

odong

Pada Kamis, 18 Desember 2014 17:15, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Odong,Sila lihat jawaban terlampir.
Salam,HK
From: "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, 18 December 2014, 13:10
Subject: [belajar-excel] input ppn masukan [1 Attachment]

 
dearall, saya ingin menanyakan tentang bagaimana penyelesaian untuk penginputan no faktur pajak maka akan otomatis akan keluarno npwp.
untuk lebih jelas nya tolong lihat lampiran

 thx,

odong

#yiv5714729134 -- #yiv5714729134ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5714729134 #yiv5714729134ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5714729134 #yiv5714729134ygrp-mkp #yiv5714729134hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5714729134 #yiv5714729134ygrp-mkp #yiv5714729134ads {margin-bottom:10px;}#yiv5714729134 #yiv5714729134ygrp-mkp .yiv5714729134ad {padding:0 0;}#yiv5714729134 #yiv5714729134ygrp-mkp .yiv5714729134ad p {margin:0;}#yiv5714729134 #yiv5714729134ygrp-mkp .yiv5714729134ad a {color:#0000ff;text-decoration:none;}#yiv5714729134 #yiv5714729134ygrp-sponsor #yiv5714729134ygrp-lc {font-family:Arial;}#yiv5714729134 #yiv5714729134ygrp-sponsor #yiv5714729134ygrp-lc #yiv5714729134hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5714729134 #yiv5714729134ygrp-sponsor #yiv5714729134ygrp-lc .yiv5714729134ad {margin-bottom:10px;padding:0 0;}#yiv5714729134 #yiv5714729134actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5714729134 #yiv5714729134activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5714729134 #yiv5714729134activity span {font-weight:700;}#yiv5714729134 #yiv5714729134activity span:first-child {text-transform:uppercase;}#yiv5714729134 #yiv5714729134activity span a {color:#5085b6;text-decoration:none;}#yiv5714729134 #yiv5714729134activity span span {color:#ff7900;}#yiv5714729134 #yiv5714729134activity span .yiv5714729134underline {text-decoration:underline;}#yiv5714729134 .yiv5714729134attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5714729134 .yiv5714729134attach div a {text-decoration:none;}#yiv5714729134 .yiv5714729134attach img {border:none;padding-right:5px;}#yiv5714729134 .yiv5714729134attach label {display:block;margin-bottom:5px;}#yiv5714729134 .yiv5714729134attach label a {text-decoration:none;}#yiv5714729134 blockquote {margin:0 0 0 4px;}#yiv5714729134 .yiv5714729134bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5714729134 .yiv5714729134bold a {text-decoration:none;}#yiv5714729134 dd.yiv5714729134last p a {font-family:Verdana;font-weight:700;}#yiv5714729134 dd.yiv5714729134last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5714729134 dd.yiv5714729134last p span.yiv5714729134yshortcuts {margin-right:0;}#yiv5714729134 div.yiv5714729134attach-table div div a {text-decoration:none;}#yiv5714729134 div.yiv5714729134attach-table {width:400px;}#yiv5714729134 div.yiv5714729134file-title a, #yiv5714729134 div.yiv5714729134file-title a:active, #yiv5714729134 div.yiv5714729134file-title a:hover, #yiv5714729134 div.yiv5714729134file-title a:visited {text-decoration:none;}#yiv5714729134 div.yiv5714729134photo-title a, #yiv5714729134 div.yiv5714729134photo-title a:active, #yiv5714729134 div.yiv5714729134photo-title a:hover, #yiv5714729134 div.yiv5714729134photo-title a:visited {text-decoration:none;}#yiv5714729134 div#yiv5714729134ygrp-mlmsg #yiv5714729134ygrp-msg p a span.yiv5714729134yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5714729134 .yiv5714729134green {color:#628c2a;}#yiv5714729134 .yiv5714729134MsoNormal {margin:0 0 0 0;}#yiv5714729134 o {font-size:0;}#yiv5714729134 #yiv5714729134photos div {float:left;width:72px;}#yiv5714729134 #yiv5714729134photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5714729134 #yiv5714729134photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5714729134 #yiv5714729134reco-category {font-size:77%;}#yiv5714729134 #yiv5714729134reco-desc {font-size:77%;}#yiv5714729134 .yiv5714729134replbq {margin:4px;}#yiv5714729134 #yiv5714729134ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5714729134 #yiv5714729134ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5714729134 #yiv5714729134ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5714729134 #yiv5714729134ygrp-mlmsg select, #yiv5714729134 input, #yiv5714729134 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5714729134 #yiv5714729134ygrp-mlmsg pre, #yiv5714729134 code {font:115% monospace;}#yiv5714729134 #yiv5714729134ygrp-mlmsg * {line-height:1.22em;}#yiv5714729134 #yiv5714729134ygrp-mlmsg #yiv5714729134logo {padding-bottom:10px;}#yiv5714729134 #yiv5714729134ygrp-msg p a {font-family:Verdana;}#yiv5714729134 #yiv5714729134ygrp-msg p#yiv5714729134attach-count span {color:#1E66AE;font-weight:700;}#yiv5714729134 #yiv5714729134ygrp-reco #yiv5714729134reco-head {color:#ff7900;font-weight:700;}#yiv5714729134 #yiv5714729134ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5714729134 #yiv5714729134ygrp-sponsor #yiv5714729134ov li a {font-size:130%;text-decoration:none;}#yiv5714729134 #yiv5714729134ygrp-sponsor #yiv5714729134ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5714729134 #yiv5714729134ygrp-sponsor #yiv5714729134ov ul {margin:0;padding:0 0 0 8px;}#yiv5714729134 #yiv5714729134ygrp-text {font-family:Georgia;}#yiv5714729134 #yiv5714729134ygrp-text p {margin:0 0 1em 0;}#yiv5714729134 #yiv5714729134ygrp-text tt {font-size:120%;}#yiv5714729134 #yiv5714729134ygrp-vital ul li:last-child {border-right:none !important;}#yiv5714729134

Sat Dec 20, 2014 10:55 am (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Odong,

Coba formula berikut di sebuah cell hasil :
=LOOKUP(2,1/(($A$2:$A$5<=L2)*($B$2:$B$5>=L2)),$C$2:$C$5)
copy ke bawah

*** jika regional setting komputer setempat adalah Indonesian, ganti
seluruh karakter koma dalam formula dengan titik koma.

Wassalam,
Kid.

2014-12-18 17:10 GMT+11:00 odong nando odongnando@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:

>
>
>
> dear all,
> saya ingin menanyakan tentang bagai mana penyelesaian untuk penginputan no
> faktur pajak maka akan otomatis akan keluar no npwp.
>
> untuk lebih jelas nya tolong lihat lampiran
>
>
> thx,
>
> odong
>
>
>
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar