请教个问题，某一单元格包含（不是等于） A或B或C.....，另一单元格等于是怎么调公式？

Question

如题所述

Answer 1

假如数据在A1单元格，B1单元格公式=LOOKUP(1,0/find({"A","B","C","D","E"},A1),{"1","2","3","4","5"})
公式说明：只要A1单元格中分别含有A、B、C、D、E字符，B1单元格就分别返回1、2、3、4、5。含有的字符和返回的内容可由你任意自定义。

Answer 2

=if(count(find({"A","B","C"},a1),成立时的值,不成立时的值)追问

Answer 3

=IF(OR(COUNT(FIND({"A","B","C"},A1))),"是","")
或
=IF(OR(ISNUMBER(FIND({"A","B","C"},A1))),"是","")本回答被提问者采纳