用excel得到个税速算扣除数

2025-05-23 07:59:22
推荐回答(2个)
回答(1):

请列示,各个分段应纳税所得额对应的税率

回答(2):

X1=LOOKUP(W2,{1,1501,4501,9001,35001,55001,80001;"3%","10%","20%","25%","30%","35%","45%"})
Y1=LOOKUP(W2,{1,1501,4501,9001,35001,55001,80001;0,105,555,1005,2755,5505,13505})