相关文章

税后工资及税前工资倒推个人所得税的函数计算公式

来源网址:

=MAX((G6-3500-5*{0,21,111,201,551,1101,2701})/(1-5%*{0.6,2,4,5,6,7,9}) 3500,G6)

结果是5,500.00元

=MIN(3500 (G10 5*{0,21,111,201,551,1101,2701})/(5%*{0.6,2,4,5,6,7,9}))