知道应缴个人所得税税额倒算工资 ,求EXCEL公式。答:倒推税前1=MAX((实发-5000-{0,210,1410,2660,4410,7160,15160})/(1-{3,10,20,25,30,35,45}%)+5000,实发)+SUM(扣除的几险几金)倒推税前2=MIN((税金+{0,210,1410,2660,4410,7160,15160})/{3,10,20,25,30,35,45}%)+5000+SUM(社保)即:=MIN((税金+{速算扣除数})/{税率}...
2018年以后的新税法,个人所得税(正常工资薪金)已知应纳税额倒算应...答:用公式:(假设个税值在A1)=IF(A1=0,"<=5000",MIN((A1+{0,210,1410,2660,4410,7160,15160})/{0.03,0.1,0.2,0.25,0.3,0.35,0.45}+5000))