举例求教：excel区间函数公式
的有关信息介绍如下：
在A2单元格输入公式：=IF(A1<0.5,"",IF(A1<3,0.2,IF(A1<6,0.3,IF(A1<30,0.5,IF(A1<120,0.8,IF(A1<400,1.2,""))))))或者：=IF(OR(A1<0.5,A1>400),"",LOOKUP(A1,{0,3,6,30,120},{0.2,0.3,0.5,0.8,1.2}))
举例求教：excel区间函数公式
Simone
发布于 2026-01-29 02:35:56
505 阅读
