2018年10月1日起个人所得税excel计算公式？

Answer 1

2018年10月1日起个人所得税excel计算公式：= ROUND(MAX((A2-B2-C2-D2-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)。

计算公式使用方法：

1、首先在excel表格中输入对应的数据，A2为税前工资，B2为专项扣除，C2为专项附加扣除,D2为其他扣除。

2、然后在E2单元格中输入公式：= ROUND(MAX((A2-B2-C2-D2-5000)*

{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)。

3、按下回车键即可得到该栏目对应的需要缴纳的个税金额了。

4、如果需要大量计算个税金额，可以选中E2单元格，点击右下角的绿色圆点向下拖拽填充公式即可。

Answer 2

=IF(A1>=85000,(A1-5000)*45%-15160,IF(A1>=60000,(A1-5000)*35%-7160,IF(A1>=40000,(A1-5000)*30%-4410,IF(A1>=30000,(A1-5000)*25%-2660,IF(A1>=17000,(A1-5000)*20%-1410,IF(A1>=8000,(A1-5000)*10%-210,IF(A1>5000,(A1-5000)*3%,)))))))

Answer 3

=IF(AND(Y18>0,Y18<=5000),0,IF(AND(Y18>5000,Y18<=8000),ROUND((Y18-5000)*0.03,2),IF(AND(Y18>8000,Y18<=17000),ROUND((Y18-5000)*0.1-210,2),IF(AND(Y18>17000,Y18<=30000),ROUND((Y18-5000)*0.2-1410,2),IF(AND(Y18>30000,Y18<=40000),ROUND((Y18-5000)*0.25-2660,2),IF(AND(Y18>40000,Y18<=60000),ROUND((Y18-5000)*0.30-4410,2),IF(AND(Y18>60000,Y18<=85000),ROUND((Y18-5000)*0.35-7160,2),IF(AND(Y18>85000),ROUND((Y18-5000)*0.45-15160,2),""))))))))

Answer 4

=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)

Answer 5

起征点改一下就行了，没啥难度

追问

=ROUND(MAX((C5-5000)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)
从公式分析，不仅起征点发生了变化——由3500变成了5000，速算扣除数也相应发生了变化！