RE: ]] XL-mania [[ formula excel pajak pendapatan

 

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+(((A1)-250000000)*0.25),95000000+(((A1)-500000000)*0.3)))),0)

 

 

Cell A1 & B1.

A	B
325,680,000	51,420,000

 

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] 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!

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 44

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat jalan SitiVi, semoga bahagia di sisi-Nya...               |
| Maaf moderasi lemooOooOott... momods siboek                       |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___