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
  #yiv8692294262 #yiv8692294262 -- #yiv8692294262ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8692294262 
#yiv8692294262ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8692294262 
#yiv8692294262ygrp-mkp #yiv8692294262hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8692294262 #yiv8692294262ygrp-mkp #yiv8692294262ads 
{margin-bottom:10px;}#yiv8692294262 #yiv8692294262ygrp-mkp .yiv8692294262ad 
{padding:0 0;}#yiv8692294262 #yiv8692294262ygrp-mkp .yiv8692294262ad p 
{margin:0;}#yiv8692294262 #yiv8692294262ygrp-mkp .yiv8692294262ad a 
{color:#0000ff;text-decoration:none;}#yiv8692294262 #yiv8692294262ygrp-sponsor 
#yiv8692294262ygrp-lc {font-family:Arial;}#yiv8692294262 
#yiv8692294262ygrp-sponsor #yiv8692294262ygrp-lc #yiv8692294262hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8692294262 
#yiv8692294262ygrp-sponsor #yiv8692294262ygrp-lc .yiv8692294262ad 
{margin-bottom:10px;padding:0 0;}#yiv8692294262 #yiv8692294262actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8692294262 
#yiv8692294262activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8692294262
 #yiv8692294262activity span {font-weight:700;}#yiv8692294262 
#yiv8692294262activity span:first-child 
{text-transform:uppercase;}#yiv8692294262 #yiv8692294262activity span a 
{color:#5085b6;text-decoration:none;}#yiv8692294262 #yiv8692294262activity span 
span {color:#ff7900;}#yiv8692294262 #yiv8692294262activity span 
.yiv8692294262underline {text-decoration:underline;}#yiv8692294262 
.yiv8692294262attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8692294262 .yiv8692294262attach div a 
{text-decoration:none;}#yiv8692294262 .yiv8692294262attach img 
{border:none;padding-right:5px;}#yiv8692294262 .yiv8692294262attach label 
{display:block;margin-bottom:5px;}#yiv8692294262 .yiv8692294262attach label a 
{text-decoration:none;}#yiv8692294262 blockquote {margin:0 0 0 
4px;}#yiv8692294262 .yiv8692294262bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8692294262 
.yiv8692294262bold a {text-decoration:none;}#yiv8692294262 dd.yiv8692294262last 
p a {font-family:Verdana;font-weight:700;}#yiv8692294262 dd.yiv8692294262last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8692294262 
dd.yiv8692294262last p span.yiv8692294262yshortcuts 
{margin-right:0;}#yiv8692294262 div.yiv8692294262attach-table div div a 
{text-decoration:none;}#yiv8692294262 div.yiv8692294262attach-table 
{width:400px;}#yiv8692294262 div.yiv8692294262file-title a, #yiv8692294262 
div.yiv8692294262file-title a:active, #yiv8692294262 
div.yiv8692294262file-title a:hover, #yiv8692294262 div.yiv8692294262file-title 
a:visited {text-decoration:none;}#yiv8692294262 div.yiv8692294262photo-title a, 
#yiv8692294262 div.yiv8692294262photo-title a:active, #yiv8692294262 
div.yiv8692294262photo-title a:hover, #yiv8692294262 
div.yiv8692294262photo-title a:visited {text-decoration:none;}#yiv8692294262 
div#yiv8692294262ygrp-mlmsg #yiv8692294262ygrp-msg p a 
span.yiv8692294262yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8692294262 
.yiv8692294262green {color:#628c2a;}#yiv8692294262 .yiv8692294262MsoNormal 
{margin:0 0 0 0;}#yiv8692294262 o {font-size:0;}#yiv8692294262 
#yiv8692294262photos div {float:left;width:72px;}#yiv8692294262 
#yiv8692294262photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv8692294262 
#yiv8692294262photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8692294262
 #yiv8692294262reco-category {font-size:77%;}#yiv8692294262 
#yiv8692294262reco-desc {font-size:77%;}#yiv8692294262 .yiv8692294262replbq 
{margin:4px;}#yiv8692294262 #yiv8692294262ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8692294262 #yiv8692294262ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8692294262 
#yiv8692294262ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8692294262 
#yiv8692294262ygrp-mlmsg select, #yiv8692294262 input, #yiv8692294262 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8692294262 
#yiv8692294262ygrp-mlmsg pre, #yiv8692294262 code {font:115% 
monospace;}#yiv8692294262 #yiv8692294262ygrp-mlmsg * 
{line-height:1.22em;}#yiv8692294262 #yiv8692294262ygrp-mlmsg #yiv8692294262logo 
{padding-bottom:10px;}#yiv8692294262 #yiv8692294262ygrp-msg p a 
{font-family:Verdana;}#yiv8692294262 #yiv8692294262ygrp-msg 
p#yiv8692294262attach-count span {color:#1E66AE;font-weight:700;}#yiv8692294262 
#yiv8692294262ygrp-reco #yiv8692294262reco-head 
{color:#ff7900;font-weight:700;}#yiv8692294262 #yiv8692294262ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv8692294262 #yiv8692294262ygrp-sponsor 
#yiv8692294262ov li a {font-size:130%;text-decoration:none;}#yiv8692294262 
#yiv8692294262ygrp-sponsor #yiv8692294262ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8692294262 
#yiv8692294262ygrp-sponsor #yiv8692294262ov ul {margin:0;padding:0 0 0 
8px;}#yiv8692294262 #yiv8692294262ygrp-text 
{font-family:Georgia;}#yiv8692294262 #yiv8692294262ygrp-text p {margin:0 0 1em 
0;}#yiv8692294262 #yiv8692294262ygrp-text tt {font-size:120%;}#yiv8692294262 
#yiv8692294262ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv8692294262 

  

Kirim email ke