= IF(a 1 & lt;0.5,“”,如果(a 1 & lt;3,0.2,如果(a 1 & lt;6,0.3,如果(a 1 & lt;30,0.5,如果(a 1 & lt;120,0.8,如果(a 1 & lt;400,1.2,""))))))
或者:
= IF(OR(a 1 & lt;0.5,a 1 & gt;400)、“”、LOOKUP(A1,{0,3,6,30,120}、{0.2,0.3,0.5,0.8,1.2}))