在EXCEL里怎么计算个所税公式?
发布网友
发布时间：2022-04-22 07:44
共1个回答
热心网友
时间：2022-06-17 23:36
税率：ROUND(IF(W8<=0,0,IF(W8<=500,5,IF(W8<=2000,10,IF(W8<=5000,15,IF(W8<=20000,20,IF(W8<=40000,25,IF(W8<=60000,30))))))),2)
扣除数：ROUND(IF(W8<=0,0,IF(W8<=500,0,IF(W8<=2000,25,IF(W8<=5000,125,IF(W8<=20000,375,IF(W8<=40000,1375,IF(W8<=60000,3375))))))),2)
应纳税额：ROUND(IF(W8<=0,0,IF(W8<=500,W8*5/100,IF(W8<=2000,W8*10/100-25,IF(W8<=5000,W8*15%-125,IF(W8<=20000,W8*20%-375,IF(W8<=40000,W8*25%-1375,IF(W8<=60000,W8*30%-3375))))))),2)
根据实际改下单元格就ok.
