Question

EXCEL表中，新税率个人所得税用 IF 函数怎么计算，

希望是有速算扣除数的算法
假设A1为应纳税所得额
要求保留2位小数，不扣个人所得税的时候不显示0

Answer 1

=IF(H441-P441<0,0,IF(H441-P441<1500,0.03*(H441-P441),IF(H441-P441<4500,0.1*(H441-P441)-105,IF(H441-P441<9000,0.2*(H441-P441)-555,IF(H441-P441<35000,0.25*(H441-P441)-1005,IF(H441-P441<55000,0.3*(H441-P441)-2755,IF(H441-P441<80000,0.35*(H441-P441)-5505)))))))

Answer 2

在Excel中计算个人所得税

Answer 3

Answer 4

给你推荐个网站：http://www.51labour.com/zhuanti/2008protax/ 里边有现成的个人所得税计算器，你用一下很方便得。

Answer 5

=IF(H441-P441<0,0,IF(H441-P441<1500,0.03*(H441-P441),IF(H441-P441<4500,0.1*(H441-P441)-105,IF(H441-P441<9000,0.2*(H441-P441)-555,IF(H441-P441<35000,0.25*(H441-P441)-1005,IF(H441-P441<55000,0.3*(H441-P441)-2755,IF(H441-P441<80000,0.35*(H441-P441)-5505)))))))

H441-P441 就是你的A1