=IF(A1<0,0,IF(A1<1500,0.03*(A1),IF(A1<4500,0.1*(A1)-105,IF(A1<9000,0.2*(A1)-555,IF(A1<35000,0.25*(A1)-1005,IF(A1<55000,0.3*(A1)-2755,IF(A1<80000,0.35*(A1)-5505)))))))
A1为超出3500之后部分
=ROUND(MAX((M1-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)
M1为应发减去社保公积金后的计税工资
这两个公式都可以用
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024