免费问答

下午好！ 按下述公式可计算税前工资，其中A1需要设成你实际取值的税后工资单元格 =ROUND(MAX((A1-5000-{0,0,210,1410,2660,4410,7160,15160})/(1-{0,0.03,0.1,0.2,0.25,0.3,0.35,0.45}))+5000,2) A1=税后工资收入(已扣社保等五金)