mas tobi, mungkin lampiran berikut akan lebih jelas. mas winarno, wah senang banget rasanya bisa nemuin formulanya, namun setelah saya coba ke inv tagihan ternyata masih ada yang nilai yang false, seperti terlampir. mas zainul, betul mas, namun yang saya maksud adalah inv valas, jadi harus di pecah dulu nilai yang ditagihkan menjadi dpp dan ppn, yang wajar adalah nilai 2 angka di belakang koma, setelah itu hasilnya baru di kalikan dengan KMK sesuai tgl inv. barulah di bulatkan hingga rupiah penuh nilai ppn nya. br,
odong nando
Pada Rabu, 24 Februari 2016 8:54, "'zainul_ulum[at]yahoo[dot]com'
[email protected] [belajar-excel]" <[email protected]> menulis:
maaf ikut nimbrung.bukankah perhitungan PPN menurut SE-22/PJ.24/1990
dibulatkan ke bawah hingga rupiah penuh?sehingga rumus PPN nya menjadi sehingga
fungsi excel yang cocok bukan ROUND tetapi TRUNC() ppn =trunc(0.1*dpp1)
mohon koreksinya jika salah-zainul From: [email protected]
[mailto:[email protected]]
Sent: Wednesday, February 24, 2016 8:14 AM
To: [email protected]
Subject: Bls: [belajar-excel] mencari nilai dpp dan ppn diakalin aja lah
dpp1 pake round pembulatan 3dpp2 =round(dpp1;2)ppn =round(0.1*dpp1;2)
total = dpp2 + ppn hasilnya true semua
__Winarno__ Pada Selasa, 23 Februari 2016 18:14, "odong nando
[email protected] [belajar-excel]" <[email protected]> menulis:
dear all, sebetulnya sudah lama saya menghadapi kondisi menyulitkan ini,
namun transaksi masih sedikit menjadi bukan masalah yang berarti, namun semakin
berkembangnya perusahaan ternyata saya dapat mencari nilai dpp dan ppn sampai
seharian. sudah jadi masalah sekarang... hehe... mohon solusi untuk mencari
nilai dpp dan ppn seperti terlampir br,
odong nando #yiv7189910196 #yiv7189910196 -- #yiv7189910196ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv7189910196 #yiv7189910196ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv7189910196 #yiv7189910196ygrp-mkp #yiv7189910196hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7189910196 #yiv7189910196ygrp-mkp #yiv7189910196ads
{margin-bottom:10px;}#yiv7189910196 #yiv7189910196ygrp-mkp .yiv7189910196ad
{padding:0 0;}#yiv7189910196 #yiv7189910196ygrp-mkp .yiv7189910196ad p
{margin:0;}#yiv7189910196 #yiv7189910196ygrp-mkp .yiv7189910196ad a
{color:#0000ff;text-decoration:none;}#yiv7189910196 #yiv7189910196ygrp-sponsor
#yiv7189910196ygrp-lc {font-family:Arial;}#yiv7189910196
#yiv7189910196ygrp-sponsor #yiv7189910196ygrp-lc #yiv7189910196hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7189910196
#yiv7189910196ygrp-sponsor #yiv7189910196ygrp-lc .yiv7189910196ad
{margin-bottom:10px;padding:0 0;}#yiv7189910196 #yiv7189910196actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7189910196
#yiv7189910196activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7189910196
#yiv7189910196activity span {font-weight:700;}#yiv7189910196
#yiv7189910196activity span:first-child
{text-transform:uppercase;}#yiv7189910196 #yiv7189910196activity span a
{color:#5085b6;text-decoration:none;}#yiv7189910196 #yiv7189910196activity span
span {color:#ff7900;}#yiv7189910196 #yiv7189910196activity span
.yiv7189910196underline {text-decoration:underline;}#yiv7189910196
.yiv7189910196attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7189910196 .yiv7189910196attach div a
{text-decoration:none;}#yiv7189910196 .yiv7189910196attach img
{border:none;padding-right:5px;}#yiv7189910196 .yiv7189910196attach label
{display:block;margin-bottom:5px;}#yiv7189910196 .yiv7189910196attach label a
{text-decoration:none;}#yiv7189910196 blockquote {margin:0 0 0
4px;}#yiv7189910196 .yiv7189910196bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7189910196
.yiv7189910196bold a {text-decoration:none;}#yiv7189910196 dd.yiv7189910196last
p a {font-family:Verdana;font-weight:700;}#yiv7189910196 dd.yiv7189910196last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7189910196
dd.yiv7189910196last p span.yiv7189910196yshortcuts
{margin-right:0;}#yiv7189910196 div.yiv7189910196attach-table div div a
{text-decoration:none;}#yiv7189910196 div.yiv7189910196attach-table
{width:400px;}#yiv7189910196 div.yiv7189910196file-title a, #yiv7189910196
div.yiv7189910196file-title a:active, #yiv7189910196
div.yiv7189910196file-title a:hover, #yiv7189910196 div.yiv7189910196file-title
a:visited {text-decoration:none;}#yiv7189910196 div.yiv7189910196photo-title a,
#yiv7189910196 div.yiv7189910196photo-title a:active, #yiv7189910196
div.yiv7189910196photo-title a:hover, #yiv7189910196
div.yiv7189910196photo-title a:visited {text-decoration:none;}#yiv7189910196
div#yiv7189910196ygrp-mlmsg #yiv7189910196ygrp-msg p a
span.yiv7189910196yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7189910196
.yiv7189910196green {color:#628c2a;}#yiv7189910196 .yiv7189910196MsoNormal
{margin:0 0 0 0;}#yiv7189910196 o {font-size:0;}#yiv7189910196
#yiv7189910196photos div {float:left;width:72px;}#yiv7189910196
#yiv7189910196photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7189910196
#yiv7189910196photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7189910196
#yiv7189910196reco-category {font-size:77%;}#yiv7189910196
#yiv7189910196reco-desc {font-size:77%;}#yiv7189910196 .yiv7189910196replbq
{margin:4px;}#yiv7189910196 #yiv7189910196ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7189910196 #yiv7189910196ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7189910196
#yiv7189910196ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7189910196
#yiv7189910196ygrp-mlmsg select, #yiv7189910196 input, #yiv7189910196 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7189910196
#yiv7189910196ygrp-mlmsg pre, #yiv7189910196 code {font:115%
monospace;}#yiv7189910196 #yiv7189910196ygrp-mlmsg *
{line-height:1.22em;}#yiv7189910196 #yiv7189910196ygrp-mlmsg #yiv7189910196logo
{padding-bottom:10px;}#yiv7189910196 #yiv7189910196ygrp-msg p a
{font-family:Verdana;}#yiv7189910196 #yiv7189910196ygrp-msg
p#yiv7189910196attach-count span {color:#1E66AE;font-weight:700;}#yiv7189910196
#yiv7189910196ygrp-reco #yiv7189910196reco-head
{color:#ff7900;font-weight:700;}#yiv7189910196 #yiv7189910196ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7189910196 #yiv7189910196ygrp-sponsor
#yiv7189910196ov li a {font-size:130%;text-decoration:none;}#yiv7189910196
#yiv7189910196ygrp-sponsor #yiv7189910196ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7189910196
#yiv7189910196ygrp-sponsor #yiv7189910196ov ul {margin:0;padding:0 0 0
8px;}#yiv7189910196 #yiv7189910196ygrp-text
{font-family:Georgia;}#yiv7189910196 #yiv7189910196ygrp-text p {margin:0 0 1em
0;}#yiv7189910196 #yiv7189910196ygrp-text tt {font-size:120%;}#yiv7189910196
#yiv7189910196ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7189910196
dpp_ppn-1.xlsx
Description: MS-Excel 2007 spreadsheet
