[求助]关于2008年3月后个人所得税的相关函数设计

wanter1980

<p>不防看一下这个：</p><p><a href="http://club.excelhome.net/viewthread.php?tid=311118&amp;px=0">http://club.excelhome.net/viewthread.php?tid=311118&amp;px=0</a></p>

zoujz1978

<p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">公式一</span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"></span><span lang="EN-US" style="FONT-SIZE: 12pt;"><font face="Times New Roman">=ROUND(MAX((<span style="COLOR: red;">A1</span>-2000)*{0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}-{0,0,25,125,375,1375,3375,6375,10375,15375}),2)<p></p></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">公式二</span><span lang="EN-US" style="FONT-SIZE: 12pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: red;"><font face="Times New Roman">=ROUND(MAX(0,(A1-2000)*0.05,(A1-2000)*0.1-25,(A1-2000)*0.15-125,(A1-2000)*0.2-375,(A1-2000)*0.25-1375,(A1-2000)*0.3-3375,(A1-2000)*0.35-6375,(A1-2000)*0.4-10375,(A1-2000)*0.45-15375),2)<p></p></font></span></p>