excel设置一个比较复杂的公式，求助！
发布网友
共2个回答
热心网友
=IF(X<1500,X*3%,IF(X<7500,X*10%-100,IF(X<20000,X*20%-600,"")))
把公式中的X，换成你的单元格索引（例如：A1）即可
更新一下：
=LOOKUP(A1,{0,1500,4500,9000,35000,55000,80000,10000000},{0,0.03,0.1,0.2,0.25,0.3,0.35,0.45})*A1-LOOKUP(A1,{0,1500,4500,9000,35000,55000,80000,10000000},{0,0,100,500,1000,2000,5000,10000})
热心网友
=LOOKUP(A1,{0,1500,7500,20000},{0.03,0.1,0.2,0.2})*A1-LOOKUP(A1,{0,1500,7500,20000},{0,100,600,600})
