Hai Odong, Mungkin seperti ini...
TerimaKasih, Pada Rab, 24/2/16, odong nando [email protected] [belajar-excel] <[email protected]> menulis: Judul: Bls: [belajar-excel] mencari nilai dpp dan ppn [1 Attachment] Kepada: "[email protected]" <[email protected]> Tanggal: Rabu, 24 Februari, 2016, 9:53 AM 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 #yiv9997182649 #yiv9997182649 -- #yiv9997182649ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv9997182649 #yiv9997182649ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv9997182649 #yiv9997182649ygrp-mkp #yiv9997182649hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv9997182649 #yiv9997182649ygrp-mkp #yiv9997182649ads { margin-bottom:10px;} #yiv9997182649 #yiv9997182649ygrp-mkp .yiv9997182649ad { padding:0 0;} #yiv9997182649 #yiv9997182649ygrp-mkp .yiv9997182649ad p { margin:0;} #yiv9997182649 #yiv9997182649ygrp-mkp .yiv9997182649ad a { color:#0000ff;text-decoration:none;} #yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ygrp-lc { font-family:Arial;} #yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ygrp-lc #yiv9997182649hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ygrp-lc .yiv9997182649ad { margin-bottom:10px;padding:0 0;} #yiv9997182649 #yiv9997182649actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv9997182649 #yiv9997182649activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv9997182649 #yiv9997182649activity span { font-weight:700;} #yiv9997182649 #yiv9997182649activity span:first-child { text-transform:uppercase;} #yiv9997182649 #yiv9997182649activity span a { color:#5085b6;text-decoration:none;} #yiv9997182649 #yiv9997182649activity span span { color:#ff7900;} #yiv9997182649 #yiv9997182649activity span .yiv9997182649underline { text-decoration:underline;} #yiv9997182649 .yiv9997182649attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv9997182649 .yiv9997182649attach div a { text-decoration:none;} #yiv9997182649 .yiv9997182649attach img { border:none;padding-right:5px;} #yiv9997182649 .yiv9997182649attach label { display:block;margin-bottom:5px;} #yiv9997182649 .yiv9997182649attach label a { text-decoration:none;} #yiv9997182649 blockquote { margin:0 0 0 4px;} #yiv9997182649 .yiv9997182649bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv9997182649 .yiv9997182649bold a { text-decoration:none;} #yiv9997182649 dd.yiv9997182649last p a { font-family:Verdana;font-weight:700;} #yiv9997182649 dd.yiv9997182649last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv9997182649 dd.yiv9997182649last p span.yiv9997182649yshortcuts { margin-right:0;} #yiv9997182649 div.yiv9997182649attach-table div div a { text-decoration:none;} #yiv9997182649 div.yiv9997182649attach-table { width:400px;} #yiv9997182649 div.yiv9997182649file-title a, #yiv9997182649 div.yiv9997182649file-title a:active, #yiv9997182649 div.yiv9997182649file-title a:hover, #yiv9997182649 div.yiv9997182649file-title a:visited { text-decoration:none;} #yiv9997182649 div.yiv9997182649photo-title a, #yiv9997182649 div.yiv9997182649photo-title a:active, #yiv9997182649 div.yiv9997182649photo-title a:hover, #yiv9997182649 div.yiv9997182649photo-title a:visited { text-decoration:none;} #yiv9997182649 div#yiv9997182649ygrp-mlmsg #yiv9997182649ygrp-msg p a span.yiv9997182649yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv9997182649 .yiv9997182649green { color:#628c2a;} #yiv9997182649 .yiv9997182649MsoNormal { margin:0 0 0 0;} #yiv9997182649 o { font-size:0;} #yiv9997182649 #yiv9997182649photos div { float:left;width:72px;} #yiv9997182649 #yiv9997182649photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv9997182649 #yiv9997182649photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv9997182649 #yiv9997182649reco-category { font-size:77%;} #yiv9997182649 #yiv9997182649reco-desc { font-size:77%;} #yiv9997182649 .yiv9997182649replbq { margin:4px;} #yiv9997182649 #yiv9997182649ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv9997182649 #yiv9997182649ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv9997182649 #yiv9997182649ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv9997182649 #yiv9997182649ygrp-mlmsg select, #yiv9997182649 input, #yiv9997182649 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv9997182649 #yiv9997182649ygrp-mlmsg pre, #yiv9997182649 code { font:115% monospace;} #yiv9997182649 #yiv9997182649ygrp-mlmsg * { line-height:1.22em;} #yiv9997182649 #yiv9997182649ygrp-mlmsg #yiv9997182649logo { padding-bottom:10px;} #yiv9997182649 #yiv9997182649ygrp-msg p a { font-family:Verdana;} #yiv9997182649 #yiv9997182649ygrp-msg p#yiv9997182649attach-count span { color:#1E66AE;font-weight:700;} #yiv9997182649 #yiv9997182649ygrp-reco #yiv9997182649reco-head { color:#ff7900;font-weight:700;} #yiv9997182649 #yiv9997182649ygrp-reco { margin-bottom:20px;padding:0px;} #yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ov li a { font-size:130%;text-decoration:none;} #yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv9997182649 #yiv9997182649ygrp-sponsor #yiv9997182649ov ul { margin:0;padding:0 0 0 8px;} #yiv9997182649 #yiv9997182649ygrp-text { font-family:Georgia;} #yiv9997182649 #yiv9997182649ygrp-text p { margin:0 0 1em 0;} #yiv9997182649 #yiv9997182649ygrp-text tt { font-size:120%;} #yiv9997182649 #yiv9997182649ygrp-vital ul li:last-child { border-right:none !important; } #yiv9997182649
Copy of dpp_ppn-1_toby.xlsx
Description: MS-Excel 2007 spreadsheet
