个税起征点为5000后WPS怎么计算个税答:设单元格A1为税前工资,即月收入所在单元格。应纳税额:=ROUND(MAX((A1-5000)*0.01*{3,10,20,25,30,35,45}-{0,210,1410,2660,4410,7160,15160},0),2)税后收入:=A1-ROUND(MAX((A1-5000)*0.01*{3,10,20,25,30,35,45}-{0,210,1410,2660,4410,7160,15160},0),2)注意:在把...
if函数:请问在excel表格中如何用if函数计算工资表的个人所得税。_百度...答:12500>x>=8000,则个人所得税为(X-8000)*20%-555 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,"...