知道个税金额，如何用excel到算出应税金额？？EXCEL函数公式
A1 中输入 个税金额
B1=IF(ISNUMBER(A1),"税率:"&IF(AND(A1>=0,A1<=45),"3%",IF(AND(A1>45,A1<=345),"10%",IF(AND(A1>345,A1<=1245),"20%",IF(AND(A1>1245,A1<=7745),"25%",IF(AND(A1>7745,A1<=13745),"30%",IF(AND(A1>13745,A1<=22495),"35%",IF(A1>22495,"45%","不会"))))))),"请输入数字")
C1=IF(ISNUMBER(A1),"速算扣除数："&IF(AND(A1>=0,A1<=45),0,IF(AND(A1>45,A1<=345),105,IF(AND(A1>345,A1<=1245),555,IF(AND(A1>1245,A1<=7745),1005,IF(AND(A1>7745,A1<=13745),2755,IF(AND(A1>13745,A1<=22495),5505,IF(A1>22495,13505,"不会"))))))),"请输入数字")
D1=IF(ISNUMBER(A1),"应纳税额:"&IF(AND(A1>=0,A1<=45),A1/0.03,IF(AND(A1>45,A1<=345),(A1+105)/0.1,IF(AND(A1>345,A1<=1245),(A1+555)/0.2,IF(AND(A1>1245,A1<=7745),(A1+1005)/0.25,IF(AND(A1>7745,A1<=13745),(A1+2755)/0.3,IF(AND(A1>13745,A1<=22495),(A1+5505)/0.35,IF(A1>22495,(A1+13505)/0.45,"不会"))))))),"请输入数字")
=IF(A1<=55000,IF(A1<=0,0,(IF(A1<=1500,A1*0.03,IF(A1<=4500,A1*0.1-105,IF(A1<=9000,A1*0.2-555,IF(A1<=35000,A1*0.25-1005,A1*0.3-2755)))))),IF(A1<=80000,A1*0.35-5505,A1*0.45-13505))
I4是已知应缴个税金额。此公式可倒算出3500扣除前的工资额
知道个税金额,如何用excel到算出应税金额??EXCEL函数公式
=IF(A1<=55000,IF(A1<=0,0,(IF(A1<=1500,A1*0.03,IF(A1<=4500,A1*0.1-105,IF(A1<=9000,A1*0.2-555,IF(A1<=35000,A1*0.25-1005,A1*0.3-2755))),IF(A1<=80000,A1*0.35-5505,A1*0.45-13505))
知道个税金额,如何用excel到算出税率、速算扣除数和应税金额??如果有...
【应税金额】放在B1，我们在B1里写公式：=MIN((B1+25*{0,1,5,15,55,135,255,415,615})\/({1,2,3,4,5,6,7,8,9}*0.05))+2000 可以下拖复制！！！【税率】放在C1，C1写公式：=LOOKUP(INT((B1-2000)\/500),{0,1,4,10,40,80,120,160,200},{1,2,3,4,5,6,7,8,9}*0...
新个税下,知道个税金额,如何用excel到算出税率、速算扣除数和应税金额...
A1 中输入 个税金额 B1=IF(ISNUMBER(A1),"税率:"&IF(AND(A1>=0,A1<=45),"3%",IF(AND(A1>45,A1<=345),"10%",IF(AND(A1>345,A1<=1245),"20%",IF(AND(A1>1245,A1<=7745),"25%",IF(AND(A1>7745,A1<=13745),"30%",IF(AND(A1>13745,A1<=22495),"35%",IF(A1>22495,...
个税excel公式问题
如果应纳税所得额在A1格，根据现行的税率，那么税率格公式为=if(A1>80000,"45%",if(A1>55000,"35%",IF(A1>35000,"30",if(A1>9000,"25%",if(A1>4500,"20%",if(A1>1500,"10%",IF(A1>0,"3%",IF(A1<=0,"0%")))
已知应缴个税金额,求excel公式反推应税工资金额
=MIN((A1+{0,21,111,201,551,1101,2701}*5)\/({3,10,20,25,30,35,45}%)+3500)（此公式有一BUG，就是如果不出现缴税，应税工资一律视为3500）
知道应缴个人所得税税额倒算工资 ,求EXCEL公式。
税后工资倒推税前工资Excel计算公式 倒推税前1=MAX((实发-5000-{0,210,1410,2660,4410,7160,15160})\/(1-{3,10,20,25,30,35,45}%)+5000,实发)+SUM(扣除的几险几金)倒推税前2=MIN((税金+{0,210,1410,2660,4410,7160,15160})\/{3,10,20,25,30,35,45}%)+5000+SUM(社保)即：=...
...知道新税法下的个税应缴额,想用EXCEL公式计算出应纳个人应纳税所得...
在A1单元格输入应纳税所得额，在B1单元格输入：=IF(A1>80000,A1*0.45-13505,IF(A1>55000,A1*0.35-5505,IF(A1>35000,A1*0.3-2755,IF(A1>9000,A1*0.25-1005,IF(A1>4500,A1*0.2-555,IF(A1>1500,A1*0.1-105,IF(A1>0,A1*0.03,0)))...
用excel函数公式计算应扣工资和实发工资
1、首先打开excel，输入实发工资，提供了相关个税起征点对应的税率、速算扣除数。2、然后在个人所得税下的一个单元格中输入“=ROUND(MAX((工资所对应的单元格-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2)”回车，可以得到第一个工资对应的...
excel公式计算,知道个人所得税应纳税额,求应纳税所得额 (新个税3500起...
假设A列为应纳税额,B列为个人所得额 B2公式:=IF(A2>0,MIN(A2\/{3,10,20,25,30,35,45}%+{3500,4550,6275,7520,12683.33,19228.57,33511.11}),"3500元以下")下拉填充
个人所得税excel计算公式个人所得税excel计算公式vlookup
2660；4410；7160,15160},0)；2)三、此时我们会发现，B2显示的金额为0，这是正确的。因为个税起征点是5000，A2为4000，无需缴税。接着，我们只需要向下拖动B2单元格即可。四、得到如下表格。只要在A列里有工资输入，B列就可以自动计算出所需缴纳的个税了。用excel输入个人所得税计算公式的方法及...
