个人所得税excel计算公式

个人所得税excel计算公式

在excel中计算个人所得税

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

<=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

假如在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)))))))