个人所得税excel计算公式

2025-10-02 10:38:46

1、工资范围免征额税率应发工资个人所得税

<=5000 5000 0% x 0

<=8000 5000 3% x (x-5000)*3%

<=17000 5000 10% x (x-8000)*10%+90

<=30000 5000 20% x (x-17000)*20%+990

<=40000 5000 25% x (x-30000)*25%+3590

<=60000 5000 30% x (x-40000)*30%+6090

<=85000 5000 35% x (x-60000)*35%+12090

>85000 5000 45% x (x-85000)*45%+20840

2、假如在excel中张三的实发工资放在h8单元格中，则计算张三的个人所得税公式为：

=if(h8<=5000,0,if(h8<=8000,(h8-5000)*3%,if(h8<=17000,(h8-8000)*10%+90,if(h8<=30000,(h8-17000)*20%+990,if(h8<=40000,(h8-30000)*25%+3590,if(h8<=60000,(h8-40000)*30%+6090,if(h8<=85000,(h8-60000)*35%+12090,(h8-85000)*45%+20840)))))))

声明：本网站引用、摘录或转载内容仅供网站访问者交流或参考，不代表本站立场，如存在版权或非法内容，请联系站长删除，联系邮箱：site.kefu@qq.com。