Hi Miki,
Copy & paste formula di cell B1.
=ROUND(IF(A1<=50000000,A1*0.05,IF(AND(A1>50000000,A1<=250000000),2500000
+(((A1)-50000000)*0.15),IF(AND(A1>250000000,A1<=500000000),32500000+(((A
1)-250000000)*0.25),95000000+(((A1)-500000000)*0.3)))),0)
Cell A1 & B1.
A
B
325,680,000
51,420,000
From: [email protected] [mailto:[email protected]] On
Behalf Of Miki
Sent: Friday, November 02, 2012 8:13 AM
To: excel
Subject: ]] XL-mania [[ formula excel pajak pendapatan
Dear para pakar excel,
Saya mau tanya formula excel (salah satu bagi hitungsn pajak) :
kriteria :
1 - 50.000.000 dikenakan 5%
50.000.000 - 250.000.000 dikenakan 15%
250.000.000 - 500.000.000 dikenakan 25%
lebih besar 500.000.000 dikenakan 30 %
angka akhir yang diinginkan untuk kena persen itu 325.680.000
dimana hitung manualnya adalah :
50.000.000 x 5% = 2.500.000
200.000.000 x 15% = 30.000.000
75.680.000 x 25% = 18.920.000
Jadi total = 51.420.000
Proses formula excel yg diinginkan adalah hasil akhir = 51.420.000
Terima kasih sesudah dan sebelumnya
Salam,
Miki
Legal Disclaimer:
The information contained in this message may be privileged and confidential.
It is intended to be read only by the individual or entity to whom it is
addressed or by their designee. If the reader of this message is not the
intended recipient, you are on notice that any distribution of this message, in
any form, is strictly prohibited. If you have received this message in error,
please immediately notify the sender and delete or destroy any copy of this
message!
