excel累进制公式 excel超额累退公式

excel累进制公式

输入以下公式=2000+SUM(TEXT(A2-{0,50,100,500,1000,5000,10000,50000,100000},＂0;!0＂)*{0,0.2,-0.11,-0.02,-0.02,-0.02,-0.015,-0.005,-0.002}%)*10000 详见附图示例

假设中标金额是在A8, 公式是:=CHOOSE(SUM(1,(A8>100),(A8>500),(A8>1000),(A8>5000),(A8>10000),(A8>100000)),A8*1%,(A8-100)*0.7%+1,(A8-500)*0.55%+3.8,(A8-1000)*0.35%+6.55,(A8-5000)*0.2%+20.55,(A8-10000)*0.05%+30.55,(A8-100000)*0.01%+75.55) 其实此类多条件及无规律的步长, 应用VBA自定义函数较佳

=IF(A1>10000,(A1-10000)*0.12%+20.8,IF(A1>5000,(A1-5000)*0.12%+13.3,IF(A1>1000,(A1-1000)*0.25%+3.3,IF(A1>500,(A1-500)*0.3%+1.8,IF(A1>100,(A1-100)*0.35%+0.4,IF(A1*0.4%>=0.3,A1*0.4%,0.3))))))

excel超额累退公式

=if(a1>10000,(a1-10000)*8%+2000*5%+2000*3%,if(a1>8000,(a1-8000)*5%+2000*3%,if(a1>6000,(a1-6000)*3%,0)))

=IF(A1>100000,(A1-100000)*10%+(100000-50000)*20%+(50000-10000)*30%+10000*40%,IF(A1>50000,(A1-50000)*20%+(50000-10000)*30%+10000*40%,IF(A1>10000,(A1-10000)*30%+10000*40%,A1*40%))) 或=IF(A1>100000,(A1-100000)*10%+26000,IF(A1>50000,(A1-50000)*20%+16000,IF(A1>10000,(A1-10000)*30%+4000,A1*40%)))

在你的第一个格子中输入:如果是从1.1的二次方开始,如下公式=1*1.1^(row(a1)+1)如果从一次放开始=1*1.1^row(a1)

超额累计函数公式

=IF(A1 以上是正确的公式!

=SUMPRODUCT(5000*((ROW(INDIRECT(＂1:＂&MIN(MAX(INT(A1/5000),1),11)))-1)/100+(A1>5000)*4%))+IF(A1>55000,(A1-55000)*15%,MOD(A1,5000)*(INT(A1/5000)/100+5%))

=if(a1>10000,(a1-10000)*8%+2000*5%+2000*3%,if(a1>8000,(a1-8000)*5%+2000*3%,if(a1>6000,(a1-6000)*3%,0)))

表格所得税怎么算

=sum(5*text(c20%-5*{4,5,8,14,44,84,124,164,204},＂[

个人所得税的计算看起来比较复杂,似乎不用VBA宏编程而只用公式来计算是一件不可能的事.其实,Excel提供的函数公式不但可以计算个人所得税,而且还有很大的灵.

=IF((S5-2000)>40000,( (S5-2000)*30%-3375),IF((S5-2000)>20000,((S5-2000)*25%-1375),IF((S5-2000)>5000,((S5-2000)*20%-375),IF((S5-2000)>2000,((S5-2000)*15%-125),IF((S5-2000)>500,((S5-2000)*10%-25),IF((S5-2000)>0,((S5-2000)*5%),”0”)))))) 说明:“S5”为计税工资

在excel中计算超额累进

假设中标金额是在A8, 公式是:=CHOOSE(SUM(1,(A8>100),(A8>500),(A8>1000),(A8>5000),(A8>10000),(A8>100000)),A8*1%,(A8-100)*0.7%+1,(A8-500)*0.55%+3.8,(A8-1000)*0.35%+6.55,(A8-5000)*0.2%+20.55,(A8-10000)*0.05%+30.55,(A8-100000)*0.01%+75.55) 其实此类多条件及无规律的步长, 应用VBA自定义函数较佳

`超额累进税分档计算,如个人所得税3000,500按5%税率交25元500按10%税率交50 3000交75元.

1. 阶梯计算公式为:=SUMPRODUCT(TEXT(A2-{0,2,3}*10^5,＂0;!0＂)*{0.005,0.003,0.002})2. 如图所示: