2011年工资的个人所得税excel计算公式,月收入在3500以上,及月收入3500以下.若能发邮件,非常感谢!

283371866@qq.com
2024-12-28 04:09:37
推荐回答(1个)
回答1:

=MAX(0,a1-3500)*LOOKUP(MAX(0,a1-3500),{0,1501,4501,9001,3501,5501},{0.03,0.1,0.2,0.25,0.3,0.35})-LOOKUP(MAX(0,a1-3500),{0,1501,4501,9001,3501,5501},{0,105,555,1005,2755,5505}),a1表示总收入减去那三险一金后的金额