Coba pake rumus ini sdr. Fahrul,Kalau Penghasilan di A2 maka rumus di B2 ...
=MAX(0;A2-500000000)*30%+MAX(0;(A2-MAX(0;A2-500000000))-250000000)*25%+MAX(0;A2-MAX(0;A2-500000000)-MAX(0;(A2-MAX(0;A2-500000000))-250000000)-50000000)*15%+(A2-MAX(0;A2-500000000)-MAX(0;(A2-MAX(0;A2-500000000))-250000000)-MAX(0;A2-MAX(0;A2-500000000)-MAX(0;(A2-MAX(0;A2-500000000))-250000000)-50000000))*5% tapi tolong cek lagi nilai Pajak untuk angka Penghasilan lainapakah sudah benar ... On Sunday, May 11, 2014 4:02 PM, "[email protected] [XL-mania]" <[email protected]> wrote: salam kenal, gimana pake excel untuk mencari nilai : Penghasilan 600jt = Rp.125.000.000 Dengan catatan. 0-50jt = 5% 50jt-250jt = 15% 250jt-500jt = 25% >500jt = 30% Jawabannya secara manual sbb; 0-50jt 5% x50jt = 2.500.000 50jt-250jt 15% x 200jt = 30.000.000 250jt-500jt 25% x 250jt = 62.500.000 >500jt 30% x100jt = 30.000.000 Total = 125.000.000 kalo pake exel gimana ya ???? please bantuin donk
Pajak Penghasilan.xlsx
Description: MS-Excel 2007 spreadsheet
