问题已解决
工資表中最新個稅計算公式
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
現(xiàn)在是累計計算個稅
累計預(yù)扣預(yù)繳應(yīng)納稅所得額=累計入-累計免稅收入-累計減除費用-累計專項扣除-累計專項附加扣除-累計依法確定的其他扣除
本期應(yīng)預(yù)扣預(yù)繳稅額=(累計預(yù)扣預(yù)繳應(yīng)納稅所得額×預(yù)扣率-速算扣除數(shù))-累計已預(yù)扣預(yù)繳稅額
2019 03/24 21:25
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/24 22:28
excel表有計算公式?jīng)]
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/25 07:34
你試一下這個公式,ROUND(MAX((A4-5000)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/25 08:39
這是之前的計算公式
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/25 08:40
算出來跟實際要交稅有問題啊
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/25 09:14
個稅系統(tǒng)是累計計算的,你可以用系統(tǒng)計算
![](/wenda/img/newWd/sysp_btn_eye.png)