lookup函数是大于等于前面的值，小于后面的值
直接用IF语句好了，假设A1单元格为合同额：
=if(A1<=100,0.5%,if(A1<=300,0.6%,if(A1<=500,0.7%,if(A1<=800,0.6%,0))))
=LOOKUP(1,0/(E4>{0,100,300,500,800,1000,1500}),{0.005,0.006,0.007,0.006,0.005,0.004})
1、先加辅助行（列）写下最大值0，100，300，500，再用LOOKUP()就可以了
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024