excel表格怎么计算税款

1.如何在EXCEL中计算税额

一、alt+F11，插入模块，粘贴如下代码：Function sds(gze, qze)nse = gze - qzeSelect Case nse / 100Case 0 To 5sds = nse * 0.05Case 5 To 20sds = nse * 0.1 - 25Case 20 To 50sds = nse * 0.15 - 125Case 50 To 200sds = nse * 0.2 - 375Case 200 To 400sds = nse * 0.25 - 1375Case 400 To 600sds = nse * 0.3 - 3375Case 600 To 800sds = nse * 0.35 - 6375Case 800 To 1000sds = nse * 0.4 - 10375Case Is > 1000sds = nse * 0.45 - 15375End SelectEnd Function二、在工具-设置-安全性-宏安全-将安全级别设置为中，保存，退出后重新打开excel文档然后你就可以使用=sds（计税工资，起征点）这个公式来计算所得税了比如A1=4000，起征点2000B1输入公式=sds(A1,2000)。

2.excel怎么算税金

如某人工资2500，扣除1600，还有900，假如A1中就是900这个应纳税所得额，那么你在B1中先设一个税率，在C1中设立速扣数，D1中设公式为=A1*B1-C1,B1中的公式为=IF(AND(A1500,A12000,A15000,A120000,A140000,A160000,A1100000,0.45,0.4)））））））） 在C1中的速扣数也是这样设公式，只不过换了一下数字而已！ C1公式为：=IF(AND(A1500,A12000,A15000,A120000,A140000,A160000,A1100000,15375,10375))))))))。

3.在EXCEL里怎么计算个所税公式?

IF(S5<=3500,0,IF(S5<=5000,(S5-3500)*0.03,IF(S5<=8000,(S5-3500)*0.1-105,IF(S5<=12500,(S5-3500)*0.2-555,IF(S5<=38500,(S5-3500)*0.25-1005,IF(S5<=58500,(S5-3500)*0.3-2755,IF(S5<=83500,(S5-3500)*0.35-5505,(S5-3500)*0.45-13505）））））））注：s5是表示该格数字为扣除社保后的工资额这是按照新税率计算的。

4.电子表格税金怎么算

比如应税金额为6000=MAX(6000*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0)0.05*{1,2,3,4,5,6,7,8,9}相当于各档税率{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}25*{0,1,5,15,55,135,255,415,615}相当于各档速算扣除数{0,25,125,375,1375,3375,6375,10375,15375}按各档税率和扣除数计算应纳税额6000*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615}={300,575,775,825,125,-1575,-4275,-7975,-12675}最后再取最大值，如果小于0，则取0 ,6000元的应纳税额是825元赞同5| 评论。

5.电子表格税金怎么算

比如应税金额为6000

=MAX(6000*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0)

0.05*{1,2,3,4,5,6,7,8,9}相当于各档税率{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}

25*{0,1,5,15,55,135,255,415,615}相当于各档速算扣除数{0,25,125,375,1375,3375,6375,10375,15375}

按各档税率和扣除数计算应纳税额6000*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615}

={300,575,775,825,125,-1575,-4275,-7975,-12675}

最后再取最大值，如果小于0，则取0 ,6000元的应纳税额是825元赞同5| 评论