假设A列为全年应纳税所得额，则应纳税=IF(A1>500000,109500+(A1-500000)*0.35,IF(A1>300000,49500+(A1-300000)*0.3,IF(A1>90000,7500+(A1-90000)*0.2,IF(A1>30000,1500+(A1-30000)*0.1,A1*0.05))))，公式下拉即可。
温馨提示：答案为网友推荐，仅供参考
第1个回答 2019-05-29
如图例：
B2=SUM(TEXT(B2-{0,3,9,30,50}*10^4,"0;!0")*{5,5,10,10,5}%)
下拉
第2个回答 2019-05-27
求累办各的公式吧。
=SUM(IF({1,0},A1,-1)*VLOOKUP(A1,{0,0.03,0;1500,0.1,105;4501,0.2,555;9001,0.25,1005;35001,0.3,2755;55001,0.35,5505;80001,0.45,13505},{2,3}))
=SUM(IF({1,0},A1,-1)*VLOOKUP(A1,{0,0.03,0;1500,0.1,105;4501,0.2,555;9001,0.25,1005;35001,0.3,2755;55001,0.35,5505;80001,0.45,13505},{2,3}))
相似回答