一起使用Mid和IF :如果我的逻辑测试中有几个变量怎么办？

Question

因此，我的公式在我的栏中如下所示：=IF(MID([@bin_id],9,1)="a"，MID([@bin_id],9,1)，"PALLET")

我唯一的问题是我想在我的逻辑测试中使用几个变量。基本上我想说的是：

如果我的Mid公式等于"a，b，c，d，e，f，g“，那么就别管它了。如果它不等于这些变量，则返回文本"pallet“。

我这样做是因为我的单元格"bin_id“有仓位，不幸的是托盘位置被标记为更短，所以当我使用我的中间公式时，它不会返回我想要的变量。

Answer 1

替代解决方案：

=IF(OR(MID([@[bin id]],9,1)={"a","b","c","d","e","f","g"}),MID([@[bin id]],9,1),"PALLET")

Answer 2

使用：

=IFERROR(INDEX({"a","b","c","d","e","f","g"},MATCH(MID([@[bin_id]],9,1),{"a","b","c","d","e","f","g"},0)),"PALLET")

或者：

=IF(ISNUMBER(MATCH(MID([@[bin_id]],9,1),{"a","b","c","d","e","f","g"},0)),MID([@[bin_id]],9,1),"PALLET")