如何设置奖金 公式

发布网友 发布时间：2024-10-13 03:20

我来回答

共1个回答

热心网友 时间：2024-10-13 09:22

新个税
计算应纳个税额
=ROUND(MAX((A1-3500)*0.05*{0.6,2,4,5,6,7,9}-{0,105,555,1005,2755,5505,13505},0),2)
年终奖
=MAX(((A1/12>{0,1500,4500,9000,35000,55000,80000})*{3,10,20,25,30,35,45}%)*A1/12-{0,105,555,1005,2755,5505,13505})*12
=ROUND(MAX((A1-3500)*{3,10,20,25,30,35,45}%-{0,105,555,1005,2755,5505,13505},0),2)

知道税后工资，推算税前工资
　　=ROUND(MAX((A1-3500-{0,0,105,555,1005,2755,5505,13505})/(1-{0,0.03,0.1,0.2,0.25,0.3,0.35,0.45}))+3500,2)
　年终奖
　　　 =ROUND(MAX((A1-{0,105,555,1005,2755,5505,13505}*12)/(1-(A1/12>{0,1455,4155,7755,27255,41255,57505})*{3,10,20,25,30,35,45}%),A1),2)

知道税额推算税前工资
　　　=MIN((A1+{0;105;555;1005;2755;5505;13505})/({3;10;20;25;30;35;45}%))+3500

年终奖
　　　=MIN((A1+{0;105;555;1005;2755;5505;13505}*12)/({3;10;20;25;30;35;45}%))