問題已解決
老師您好,請教一下,個稅用EXCEL測算計(jì)稅公式是什么呢?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
你好,你試一下下面這個公式:=IF(L4<=0,0,IF(L4<=36000,3%,IF(L4<=144000,10%,IF(L4<=300000,20%,IF(L4<=420000,25%,IF(L4<=660000,30%,IF(L4<=960000,35%,45%)))))))
2022 03/10 20:46
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/10 20:47
L4是什么意思呢?
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 03/10 21:01
就是您要計(jì)算的稅前應(yīng)發(fā)工資金額
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/10 21:18
試了一下,測算數(shù)據(jù)不對
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 03/10 21:32
是什么例子呢測出來是多少
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/10 21:36
老師是這樣的,如圖這個例子如果想要測算這個員工的1-12月份個稅,該如何套用公司測算呢?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/10 21:37
是公式測算?
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 03/10 21:52
累計(jì)應(yīng)納稅這一例替為L4的計(jì)算公式就行了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 03/10 21:56
算出來是0.1,不對呀
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 03/10 22:00
那就是累計(jì)數(shù)沒有計(jì)處對的
![](https://pic1.acc5.cn/013/10/49/53_avatar_middle.jpg?t=1680262571)
易 老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 03/10 22:01
累計(jì)數(shù)=本期收入+上期累計(jì)收入-本期累計(jì)扣除
![](/wenda/img/newWd/sysp_btn_eye.png)