请高手帮忙提供2011年9月后新税率下的年终奖excel个税计算公式，非常感谢！

如题所述

举报该文章

相关建议 2011-11-01

=ROUND(12*MAX(B1*0.01*{3,10,20,25,30,35,45}-5*{0,21,111,201,551,1101,2701},0)+11*VLOOKUP(B1,{0,0.03,0;1500,0.1,105;4500,0.2,555;9000,0.25,1005;35000,0.3,2755;55000,0.35,5505;80000,0.45,13505},3,1),2)
B1为年终奖/12以后的月均数

温馨提示：内容为网友见解，仅供参考

当前网址：https://aolonic.com/aa/kkk1n54d3.html

其他看法

第1个回答 2012-03-25

=IF(A15>3500,IF(B15>0,IF(B15>18000,IF(B15>54000,IF(B15>108000,IF(B15>420000,IF(B15>660000,IF(B15>960000,B15*0.45-13505,B15*0.35-5505),B15*0.3-2755),B15*0.25-1005),B15*0.2-555),B15*0.1-105),B15*0.03),0),IF((A15+B15-3500)>0,IF((A15+B15-3500)>18000,IF((A15+B15-3500)>54000,IF((A15+B15-35000)>108000,IF((A15+B15-3500)>420000,IF((A15+B15-3500)>660000,IF((A15+B15-3500)>960000,(A15+B15-3500)*0.45-13505,(A15+B15-3500)*0.35-5505),(A15+B15-3500)*0.3-2755),(A15+B15-3500)*0.25-1005),(A15+B15-3500)*0.2-555),(A15+B15-3500)*0.1-105),(A15+B15-3500)*0.03),0))