满足特定条件，选取公式求值~~~

不懂就问呀 · 发表于 2019-8-27 09:29

求满足A1单元格为 0.6/1.1/1.8/2.5/3.0/4.0/5.0/6.0mm 这几个规格中任意一个的时候，就会选择用这个公式计算N15=1/D15*K15，怎么用条件式函数公式表示？

lh123lh1234 · 发表于 2019-8-27 10:40

=IF(FIND({"0.6","1.1","1.8","2.5","3.0","4.0","5.0","6.0"},A1,1),IFERROR(1/D15*K15,""),"")

不懂就问呀 · 发表于 2019-8-27 12:57

lh123lh1234 发表于 2019-8-27 10:40
=IF(FIND({"0.6","1.1","1.8","2.5","3.0","4.0","5.0","6.0"},A1,1),IFERROR(1/D15*K15,""),"")

不满足这些数值的时候例如是0.5的时候为啥结果显示#VALUE 哪里错了？

lh123lh1234 · 发表于 2019-8-27 14:15

不懂就问呀发表于 2019-8-27 12:57
不满足这些数值的时候例如是0.5的时候为啥结果显示#VALUE 哪里错了？

哦，忘记考虑这个，稍微改下
=IF(ISERROR(FIND({"0.6","1.1","1.8","2.5","3.0","4.0","5.0","6.0"},A1,1)),"",IFERROR(1/D15*K15,""))

lh123lh1234 · 发表于 2019-8-27 14:16

或者这样写也可以
=IFERROR(IF(FIND({"0.6","1.1","1.8","2.5","3.0","4.0","5.0","6.0"},A1,1),IFERROR(1/D15*K15,""),""),"")

不懂就问呀 · 发表于 2019-8-27 14:32

lh123lh1234 发表于 2019-8-27 14:16
或者这样写也可以
=IFERROR(IF(FIND({"0.6","1.1","1.8","2.5","3.0","4.0","5.0","6.0"},A1,1),IFERROR(1 ...

倒是不乱吗了但是满足条件的数值也显示空值啊没有计算了

lh123lh1234 · 发表于 2019-8-27 14:38

不懂就问呀发表于 2019-8-27 14:32
倒是不乱吗了但是满足条件的数值也显示空值啊没有计算了

不可能，你的D15和K15的单元格肯定没数据，这个是根据你比如的N15行写的

不懂就问呀 · 发表于 2019-8-27 15:05

lh123lh1234 发表于 2019-8-27 14:38
不可能，你的D15和K15的单元格肯定没数据，这个是根据你比如的N15行写的

有的我再表上运行了不管事在范围内跟不在条件内的都显示空值

不懂就问呀 · 发表于 2019-8-27 15:09

lh123lh1234 发表于 2019-8-27 14:15
哦，忘记考虑这个，稍微改下
=IF(ISERROR(FIND({"0.6","1.1","1.8","2.5","3.0","4.0","5.0","6.0"},A1, ...

这条的话倒是能用，不过也有问题只有在0.6的时候是会计算的后面几个就是空值了

		自动登录	找回密码
密码			免费注册

[求助] 满足特定条件，选取公式求值~~~