問題已解決
個稅公式應該怎么弄??=ROUND(MAX(((AT3/12>{0,3000,12000,25000,35000,55000,80000})*{3,10,20,25,30,35,45}%)*AT3-{0,210,1410,2660,4410,7160,15160}),2) 類似這種的
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
您好,您給的就是個人所得稅計算公式
2023 02/07 19:22
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84785022 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 02/07 19:25
這不是計算獎金的嗎
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
小林老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 02/07 19:25
您好,那您修改0,210,1410,2660,4410,7160,15160修改綜合所得速算扣除數(shù),同時AT3/12,不需要/12
![](/wenda/img/newWd/sysp_btn_eye.png)