求大神给做个 excel 差额定率累进公式!

两种方法：1. 直接写公式的话=LOOKUP(A2,{0,100,500,1000,5000,10000,50000,100000,500000,1000000},{1.500%,0.800%,0.450%,0.250%,0.100%,0.050%,0.035%,0.008%,0.006%,0.004%})2. 如有参照表，也可简化引用：=LOOKUP(A2,$G$2:$G$11,$H$2:$H$11)