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 [email protected] [belajar-excel]" <[email protected]> To: "[email protected]" <[email protected]> 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 [email protected] [belajar-excel]" <[email protected]> menulis: Hai Odong,Sila lihat jawaban terlampir. Salam,HK From: "odong nando [email protected] [belajar-excel]" <[email protected]> To: "[email protected]" <[email protected]> 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
re_input PPN Masukan (R).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
