所以我的公式在我的栏中看起来像这样:=IF(MID([@[bin_id]],9,1)="a", MID([@[bin_id]],9,1), "PALLET")
我唯一的问题是我想为我的逻辑测试使用几个变量。 基本上我想这样说:
如果我的 Mid 公式等于 "a, b, c, d, e, f, g",那就别管它了。 如果它不等于这些变量,则返回文本"托盘"。
我这样做是因为我的单元格"bin_id"具有垃圾箱位置,不幸的是托盘位置被标记为较短,因此当我使用 MID 公式时,它不会返回我想要的变量。
替代解决方案:
=IF(OR(MID([@[bin id]],9,1)={"a","b","c","d","e","f","g"}),MID([@[bin id]],9,1),"PALLET")
使用:
=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")