可以用公式：=lookup(业绩收入单元格,{0,20000,50000,80000,110000,150000},{0.02,0.03,0.04,0.05,0.06,0.07})
a3输入公式,并设置为百分比格式(你的条件中的大于小于用得有点不对,检查一下=lookup(a1/b1,{0,0.6,0.8,0.95,1.2;0.6,0.7,0.85,1,1.1})
