求在Excel中计算个人所得税的公式，谢谢！

显示全部楼层 · 2011-9-8 14:54:53

=ROUND(MAX((B2-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-5*{0,21,111,201,551,1101,2701},0),2)...

千问 · 2011-9-8 14:54:53

=IF(计税额>35000,IF(计税额<=55000,计税额*0.3-2755,IF(计税额<=80000,计税额*0.35-5505,计税额*0.45-13505)),IF(计税额<=1500,计税额*0.03,IF(计税额<=4500,计税额*0.1-105,IF(计税额<=9000,计税额*0.2-555,计税额*0.25-1005))))...

千问 · 2011-9-8 14:54:53

这个我也是偷的别人的=MAX((H3%-35)*{0.6,2,4,5,6,7,9}-{0,21,111,201,551,1101,2701},)*5...

千问 · 2011-9-8 14:54:53

所得税=（实发工资-1600）×0.03...

千问 · 2011-9-8 14:54:53

在Excel中计算个人所得税...