Question

个人所得税税率在EXCEL表中用IF函数表示怎么编写

Answer 1

以前9级时用if函数还真不方便，嵌套层数有要求，现在7级没问题了
if(E2<=1500,E2*0.03,if(E2<=4500,E2*0.1,if(E2<=9000,E2*0.2,if(E2<=35000,E2*0.25,if(E2<=55000,E2*0.3,if(E2<=80000,E2*0.35,E2*0.45))))))

追问

怎么我把公式贴进去还是显示为0啊 谢谢啊 不甚感激

Answer 2

以前9级时用if函数还真不方便，嵌套层数有要求，现在7级没问题了
if(E2<=1500,E2*0.03,if(E2<=4500,E2*0.1,if(E2<=9000,E2*0.2,if(E2<=35000,E2*0.25,if(E2<=55000,E2*0.3,if(E2<=80000,E2*0.35,E2*0.45))))))