=MAX((A1-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

题目

=MAX((A1-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
请问这个公式反推税前工资 a1是税后工资

答案

按公式个税=（工资-3500）*适用税率-速算扣除数可得工资=（个税+速算）/税率+3500
公式里面大括号内的数组运算用来判断适用的税率,max是求最大值,两个大括号的数组分别是速算扣除数和税率