...AA5是保险,AB5是公积金,那么新个税的公式应该是什么的?
发布网友
发布时间：2024-09-27 05:13
共2个回答
热心网友
时间：2024-11-21 11:19
AD5为应纳税所得=IF(AC5>3500,AC5-3500,0)
AE5为适用税率==IF(AD5=0,0,IF(AD5<=1500,3%,IF(AD5<=4500,10%,IF(AD5<=9000,20%,IF(AD5<=35000,25%,IF(AD5<=55000,30%,IF(AD5<=80000,35%,45%)))))))
AF5为速算扣除=IF(AD5<=1500,0,IF(AD5<=4500,105,IF(AD5<=9000,555,IF(AD5<=35000,1005,IF(AD5<=55000,2755,IF(AD5<=80000,5505,13505))))))
AG5为税额=IF(AD5=0,0,IF(AD5>0,ROUND((AD5*AE5AF5),2)))
热心网友
时间：2024-11-21 11:19
