=ROUND(SUM(TEXT((A2-3500-{0,3,9,18,70,110,160}*500),"[<]!0")*{0.03,0.07,0.1,0.05,0.05,0.05,0.1}),2) A2代表计税工资数 3500代表扣除基数