知道个税额，推算税前工资

计算应纳个税额 第三个公式正确吗
知道税前工资，计算应纳个税额  A1单元格是税前工资
    =ROUND(MAX((A1-3500)*0.05*{0.6,2,4,5,6,7,9}-{0,105,555,1005,2755,5505,13505},0),2)
知道税后工资，推算税前工资   D1单元格是税后工资
    =ROUND(MAX((D1-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)
知道个税额，推算税前工资    C1单元格是个税额  
  =ROUND(MIN((C1+{0,105,555,1005,2755,5505,13505})/({0.03,0.1,0.2,0.25,0.3,0.35,0.45}))+3500,2)

没有人回应

自己顶顶顶顶