excel中个人所得税如何计算？急求！！！

答案:3 悬赏:20 手机版

解决时间 2021-03-23 13:02

提问者网友：记得曾经
2021-03-22 15:09

最佳答案

五星知识达人网友：夜风逐马
2021-03-22 15:22

=IF(A1<0,0,IF(A1<1500,0.03*(A1),IF(A1<4500,0.1*(A1)-105,IF(A1<9000,0.2*(A1)-555,IF(A1<35000,0.25*(A1)-1005,IF(A1<55000,0.3*(A1)-2755,IF(A1<80000,0.35*(A1)-5505)))))))
A1为超出3500之后部分

=ROUND(MAX((M1-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)
M1为应发减去社保公积金后的计税工资

你发的是老的税率表，现在用新的了，我这两个公式都可以计算新的个税追问不懂也，我需要旧的计算方法

全部回答

1楼网友：往事隔山水
2021-03-22 16:07

=ROUND((IF((IF((F4-K4-3500)<0,0,F4-K4-3500))>80000,(IF((F4-K4-3500)<0,0,F4-K4-3500))*0.45-13505,IF((IF((F4-K4-3500)<0,0,F4-K4-3500))>35000,(IF((F4-K4-3500)<0,0,F4-K4-3500))*0.3-2755,IF((IF((F4-K4-3500)<0,0,F4-K4-3500))>9000,(IF((F4-K4-3500)<0,0,F4-K4-3500))*0.25-1005,IF((IF((F4-K4-3500)<0,0,F4-K4-3500))>4500,(IF((F4-K4-3500)<0,0,F4-K4-3500))*0.2-555,IF((IF((F4-K4-3500)<0,0,F4-K4-3500))>1500,(IF((F4-K4-3500)<0,0,F4-K4-3500))*0.1-105,IF((IF((F4-K4-3500)<0,0,F4-K4-3500))>0,(IF((F4-K4-3500)<0,0,F4-K4-3500))*0.03,0))))))),2)
F4格为工资标准，K4格为调增调减（+补贴+奖金+....-保险等）的金额

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！