第1个回答 2021-12-03
类似150>E58>0,应该写作AND(E58>0,E58<150)
或者用如下公式
=LOOKUP(E58,{0.00001,150,250,450},{0.2,0.3,0.4,0.5}%)
或
=LOOKUP(E58,{0.00001,150,250,450;0.2,0.3,0.4,0.5})%
或
=LOOKUP(E58,{0.00001,150,250,450;2,3,4,5})/1000
下拉填充
第3个回答 2021-12-03
=IF(E58>=450,0.5%,IF(E58>=250,0.4%,IF(E58>=150,0.3%,IF(E58>0,0.2%,""))))
数值从大到小降序排(450,250,150,0)
=IF(E58<=0,"",IF(E58<150,0.2%,IF(E58<250,0.3%,IF(E58<450,0.4%,0.5%))))
数值从小到大升序排(0,150,250,450)