求2018年10月新的个税公式（EXCEL）

Question

2018年10月施行新个税办法，求EXCEL计算公式，表中H3和I3单元格公式如何编写？
万分感谢！

Answer 1

2018年10月起个人所得税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表格中根据对应的数据名称输入进入，需要计算个税需要交纳的金额。

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

I3公式：

=SUMPRODUCT(TEXT(D3-E3-{0,5000,8000,17000,30000,40000,60000,85000},"0.00;\0")*{0,0.03,0.07,0.1,0.05,0.05,0.05,0.1})

或用：

=ROUND(MAX(G3*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,210,1410,2660,4410,7160,15160},0),2)

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

Answer 5

3800*10%=380-210=170.个人所得税170元