Excel計(jì)算個(gè)稅公式(2011稅法)
=IF(F15-3500<=0,0,IF(F15-3500<=1500,(F15-3500)*0.03,IF(F15-3500<=4500,(F15-3500)*0.1-105,IF(F15-3500<=9000,(F15-3500)*0.2-555,IF(F15-3500<=35000,(F15-3500)*0.25-1005,IF(F15-3500<=55000,(F15-3500)*0.3-2755,IF(F15-3500<=80000,(F15-3500)*0.35-5505,IF(F15-3500>80000,(F15-3500)*0.45-13505,0)))))))) F15是指應(yīng)納稅工資單元格 |
|
來(lái)自: sasa0511 > 《我的圖書(shū)館》