一些excel的用法

个人所得税公式：

下面的J2是放置险后工资的单元格

约2007至2011-8-31：

=ROUND(MAX((J2-2000)*{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}-{0,25,125,375,1375,3375,6375,10375,15375},0),2)

2011-9-1以后

=ROUND(MAX((J2-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2)