时间:2024-08-12 12:21:42 浏览量:
有那种APP,可以选税后工资,推算税前多少个税。
税后工资推算税前工资计算公式
税前=IF(3500<(ROUND(MAX((A5-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.4}))+3500,2)),(ROUND(MAX((A5-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.4}))+3500,2)),A5)
A5等于税后工资,不含应扣的社保费用等。
上一篇:法定盈余公积金提取会计分录