大家帮忙下固定工资的倒推表计算

pureshadow

实在看不懂你的表，提供几个公式参考一下吧：
根据个税反推税前总计：
=MIN((C12+{0,21,111,201,551,1101,2701}*5)/(0.05*{0.6,2,4,5,6,7,9})+3500)
根据税后总计反推税前总计：
=MAX((G12/5-35*{0.6,2,4,5,6,7,9}-{0,21,111,201,551,1101,2701})/(0.2-{0.6,2,4,5,6,7,9}%),G12)