在O2单元格输入公式:=IF(M2复制并下拉,即可
O2输入公式并下拉:=if(m2>=vlookup(l2,$a$4:$d$12,3,0),1.1,if(m2>=vlookup(l2,$a$4:$d$12,2,0),1,if(m2>=vlookup(l2,$a$4:$d$12,1,0),0.9,0.6)))