excel表格单元格公式 差额定率累进法计算 详见图片

excel表格单元格公式 差额定率累进法计算 详见图片

=IF(A19>100000,(A19-100000)*0.01%+75.55,IF(AND(A19>10000,A19<=100000),(A19-10000)*0.05%+30.55,IF(AND(A19>5000,A19<=10000),(A19-5000)*0.2%+20.55,IF(AND(A19>1000,A19<=5000),(A19-1000)*0.35%+6.55,IF(AND(A19>500,A19<=1000),(A19-500)*0.55%+3.8,IF(AND(A19>100,A19<=500),(A19-100)*0.7%+1,IF(AND(A19<100),(A19-100)*1%)))))))
一个问题，A10中是100000以上是吧，你的图片中是1000000，这样的话断档了，公式中最后一档按100000以上算的追问就是1000000 我也不懂为什么 中间少了个10W-100w追答那如果在10W-100w之间怎么算？追问
追答也对，比我的简洁

=A19*lookup(A19,{0,100,500,1000,5000,10000,100000},{0.01,0.007,0.0055,0.0035,0.002,0.0005,0.0001})-lookup(A19,{0,100,500,1000,5000,10000,100000},{0,1,3.8,6.55,20.55,30.55,75.55})