如果用IF函数计算出个人所得税答:假设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>...
EXCEL工资表中个人所得税的算法工式答:税率35%,速算扣除数为6375 8超过80000元至100000元的部分,税率40%,速算扣除数为10375 9超过100000元的部分, 税率45%,速算扣除数为15375 这个公式也可以 =MAX((X5-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0)X5为工资数 ...
if函数:请问在excel表格中如何用if函数计算工资表的个人所得税。答:47500>x>=12500,则个人所得税为(X-12500)*10%-1005 假设工资在A1,公式:=IF(A1<3500,0,IF(A1<5000,(A1-3500)*3%,IF(A1<8000,(A1-5000)*10%-105,IF(A1<12500,(A1-8000)*20%-555,IF(A1<47500,(A1-12500)*10%-1005,"超限")))但感觉条件有点不符合逻辑,当工资是5000、8000...