第1个回答 2014-10-29
亲,如下图,B1的公式如下,下拉:
=IF(SUMPRODUCT(ISNUMBER(FIND({2,3},A1))*1),"含有2或3","")
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5243fbf2b2119313241904d566380cd791238d79?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第2个回答 2014-10-29
=IF(AND(ISERROR(FIND(2,A1)),ISERROR(FIND(3,A1))),"否","是")
第3个回答 2014-10-29
IF(SUMPRODUCT(IFERROR(FIND({"1","2","3"},A13),))>=1,"是","否")
第4个回答 2014-10-29
=IF(OR(ISNUMBER(FIND(2,A1)),ISNUMBER(FIND(3,A1))),"是","否")本回答被提问者采纳