【分享】15种个人所得税函数公式

adinge

谢谢了，LZ

vikey2

看下``

vikey2

看下``a

qinqh_yl

<p>帮你总结为6条公式，其他的大同小异：</p><p>=SUM(TEXT(A2-{2;2.5;4;7;22;42;62;82;102}*1000,"0;!0")*5%)</p><p>=MAX((A2-2000)*5%*{1,2,3,4,5,6,7,8,9}-25*{0,1,5,15,55,135,255,415,615},)</p><p>=IF(A2&lt;=2000,,SUM(IF((A2-2000&gt;=100*{0,5,20,50,200,400,600,800,1000})*(A2-2000&lt;100*{5,20,50,200,400,600,800,1000,100000000000}),(A2-2000)*{0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45}-25*{0,1,5,15,55,135,255,415,615})))</p><p>=IF(A2&lt;=2000,,(A2-2000)*VLOOKUP((A2-2000),{0,0.05;500,0.1;2000,0.15;5000,0.2;20000,0.25;40000,0.3;60000,0.35;80000,0.4;100000,0.45},2)-VLOOKUP((A2-2000),{0,0;500,25;2000,125;5000,375;20000,1375;40000,3375;60000,6375;80000,10375;100000,15375},2))</p><p>=IF(A2&lt;=2000,,IF(A2&lt;=2500,(A2-2000)*0.05,IF(A2&lt;=4000,(A2-2000)*0.1-25,IF(A2&lt;=7000,(A2-2000)*0.15-125,IF(A2&lt;=22000,(A2-2000)*0.2-375,IF(A2&lt;=42000,(A2-2000)*0.25-1375,IF(A2&lt;=62000,(A2-2000)*0.3-3375,)))))))+IF(A2&lt;62000,,IF(A2&lt;82000,(A2-2000)*0.35-6375,IF(A2&lt;102000,(A2-2000)*0.4-10375,(A2-2000)*0.45-15375)))</p><p>=(A2&gt;2000)*((A2&gt;2000)*(A2&lt;=2500)*(A2-2000)*5%+(A2&gt;2500)*(A2&lt;=4000)*((A2-2000)*10%-25)+(A2&gt;4000)*(A2&lt;=7000)*((A2-2000)*15%-125)+(A2&gt;7000)*(A2&lt;=22000)*((A2-2000)*20%-375)+(A2&gt;22000)*(A2&lt;=42000)*((A2-2000)*25%-1375)+(A2&gt;42000)*(A2&lt;=62000)*((A2-2000)*30%-3375)+(A2&gt;62000)*(A2&lt;=82000)*((A2-2000)*35%-6375)+(A2&gt;82000)*(A2&lt;=102000)*((A2-2000)*40%-10375)+(A2&gt;102000)*((A2-2000)*45%-15375))</p><p>详见附件：</p><p></p><br/>

fw6600506

<p>正好能用了！~</p>

tigertion

学习中。。。。。。。。

hx910

xuex yixia

lwblxjskyl

<p>看看吧！</p>[em01]

chineseval

hhhhhhhhhhhhhhhhhhhhhhhhh

月光不合

分享