新个税,已知应缴税金,怎么反算出税前收入(不含五险一金)?需要EXCEL公式...答:税前工资9488.60,个税 642.72 。不含五险一金。=MAX((实发-3500-{0,105,555,1005,2755,5505,13505})/(1-{3,10,20,25,30,35,45}%)+3500,实发)+SUM(扣除的几险几金)=MAX((H5-3500-{0,105,555,1005,2755,5505,13505})/(1-{3,10,20,25,30,35,45}%)+3500,H5)+SUM(B5:...
excel中个税计算公式,个税=-(5*MIN({21,91,251,376,761,1346,3016}...答:=MAX((税前收入-3500)*{3,10,20,25,30,35,45}%-{0,105,555,1005,2755,5505,13505},)这个公式应该容易理解吧?税前收入减去3500后按各级税率计算并减速算扣除数。再来看这个公式 =MAX(税前收入*{3,10,20,25,30,35,45}%-{105,455,1255,1880,3805,6730,15080},)税前收入不减起征点,...