=IF(AND(A2>=50,A2<=60),A2*2,IF(AND(A2>=70,A2<=80),A2*3,IF(AND(A2>=90,A2<=100),A2*3,"没在范围内")))
在B1中输入或复制粘贴下列公式=IF(A1="","",LOOKUP(A1,{50,70,90},{2,3,4}))下拉填充
