公式是 IF(D7>2000,(D7-2000),0)
结果却是导致图中的结果.应该是怎么弄
excel公式问题!求个人税
答案:2 悬赏:0 手机版
解决时间 2021-06-07 19:07
- 提问者网友：流星是天使的眼泪
- 2021-06-06 18:16
最佳答案
- 五星知识达人网友：往事隔山水
- 2021-06-06 19:16
假如个人所得税应纳税所得额为E2，则：
税率=IF(AND(E2>0,E2<=500),0.05,IF(AND(E2>500,E2<=2000),0.1,IF(AND(E2>2000,E2<=5000),0.15,IF(AND(E2>5000,E2<=20000),0.2,IF(AND(E2>20000,E2<=40000),0.25,IF(AND(E2>4000,E2<=60000),0.3,IF(AND(E2>6000,E2<=80000),0.35,IF(E2>100000,0.45,0.4))))))))
速算扣除数=IF(AND(E2>0,E2<=500),0,IF(AND(E2>500,E2<=2000),25,IF(AND(E2>2000,E2<=5000),125,IF(AND(E2>5000,E2<=20000),375,IF(AND(E2>20000,E2<=40000),1375,IF(AND(E2>4000,E2<=60000),3375,IF(AND(E2>6000,E2<=80000),6375,IF(E2>100000,15375,10375))))))))
速算扣除数也可以通过税率决定，这样相对简单明显。
税率=IF(AND(E2>0,E2<=500),0.05,IF(AND(E2>500,E2<=2000),0.1,IF(AND(E2>2000,E2<=5000),0.15,IF(AND(E2>5000,E2<=20000),0.2,IF(AND(E2>20000,E2<=40000),0.25,IF(AND(E2>4000,E2<=60000),0.3,IF(AND(E2>6000,E2<=80000),0.35,IF(E2>100000,0.45,0.4))))))))
速算扣除数=IF(AND(E2>0,E2<=500),0,IF(AND(E2>500,E2<=2000),25,IF(AND(E2>2000,E2<=5000),125,IF(AND(E2>5000,E2<=20000),375,IF(AND(E2>20000,E2<=40000),1375,IF(AND(E2>4000,E2<=60000),3375,IF(AND(E2>6000,E2<=80000),6375,IF(E2>100000,15375,10375))))))))
速算扣除数也可以通过税率决定，这样相对简单明显。
全部回答
- 1楼网友：我住北渡口
- 2021-06-06 20:31
=MAX((A1-2000)*0.05*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},0)
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯