2011年年终奖的个人所得税excel计算公式，考虑当月收入3500以上及以下的

---

=IF(F5-3500<=0,0,IF(F5-3500<=1500,(F5-3500)*3%,IF(F5-3500<=4500,(F5-3500)*0.1-105,IF(F5-3500<=9000,(F5-3500)*0.2-555,IF(F5-3500<=35000,(F5-3500)*0.25-1005,IF(F5-3500<=55000,(F5-3500)*0.3-2755,IF(F5-3500<竖举=80000,(F5-3500)*0.35-5505,IF(F5-3500>80000,(F5-3500)*0.45-13505)))))))) 在源并G5中输入公式，在F5中输入工余裂碧资，

---

=IF(F5-3500<源并=0,0,IF(F5-3500<=1500,(F5-3500)*3%,IF(F5-3500<=4500,(F5-3500)*0.1-105,IF(F5-3500<=9000,(F5-3500)*0.2-555,IF(F5-3500<=35000,(F5-3500)*0.25-1005,IF(F5-3500<=55000,(F5-3500)*0.3-2755,IF(F5-3500<=80000,(F5-3500)*0.35-5505,IF(F5-3500>80000,(F5-3500)*0.45-13505))))))))在G5中输入公式，在F5中输竖举入工资，余裂碧

---