如何用电子表格中的函数公式来计算个人所得税?=IFexcel表计算个人所得税的公式假设A1单元格是要计算税金的工资数,B1单元格为税率,C1单元格为扣除数,D1单元格为应交税金税率的公式:=扣除数的公式:=IF+IF应交税金的公式:=round
如何用电子表格中的函数公式来计算个人所得税?
=IF(A1-2000<=0,0,IF(A1-2000<=500,(A1-2000)*5%,IF(A1-2000<=2000,(A1-2000)*10%-25,IF(A1-2000<=5000,(A1-2000)*15%-125,IF(A1-2000<=20000,(A1-2000)*20%-375,IF(A1-2000<=40000,((A1-2000)*25%-1375),IF(A1-2000<=60000,(A1-2000)*30%-3375,(A1-2000)*35%-6375)))))))excel表计算个人所得税的公式
假设A1单元格是要计算税金的工资数,B1单元格为税率,C1单元格为扣除数,D1单元格为应交税金税率的公式:=(IF(AND(A1>0,A1<=500),5%,IF(AND(A1>500,A1<=2000),10%,IF(AND(A1>2000,A1<=5000),15%,IF(AND(A1>5000,A1<=20000),20%,IF(AND(A1>20000,A1<=40000),25%,IF(AND(A1>40000,A1<=60000),30%,IF(AND(A1>60000,A1<=80000),35%,0)))))))+IF(AND(A1>80000,A1<=100000),40%,IF(A1>100000,45%,0)))
扣除数的公式:=IF(B1=5%,0,IF(B1=10%,25,IF(B1=15%,125,IF(B1=20%,375,IF(B1=25%,1375,IF(B1=30%,3375,IF(B1=35%,6375,IF(B1=40%,10375,0))))))))+IF(B1=45%,15375,0)
应交税金的公式:=round(A1*B1-C1,2)