帮忙大师们给写个公式，谢谢！！！

我自狂歌

624134745

=IF(COUNT(SEARCH({"4*8","8*4","1*5","5*1","5*9","9*5","6*9","9*6"},E2)),"是","不是")

mountain119

1. =IF(IFERROR(AND(FIND(MID(E2,{1,2,3},1),CONCAT(84,15,59,69))>0),0),"是","不是")

复制代码

是这个意思吗？

yibao2

=IF(OR(MMULT(1-ISERR(FIND({8,4;1,5;5,9;6,9},E2)),{1;1})>1),"是","不是")

袁勇

=IF(OR(MMULT(ISNUMBER(FIND({8,4;1,5;5,9;6,9},E2))*1,{1;1})=2),"是","不是")

我自狂歌

mountain119 发表于 2024-5-15 16:17
是这个意思吗？

有点问题，楼上的就合适了！但也特别感谢！

bsgn2017

1. =IF(OR(MID(CONCAT(CHOOSEROWS(MID(E2,ROW($1:$3),1),1,2,2,3,1,3,2,1,3,1,3,2)),ROW($1:$6)*2-1,2)^1={84,15,59,69}),"是",“不是”)

复制代码

↓拉

浮生若梦~~~

624134745 发表于 2024-5-15 16:14
=IF(COUNT(SEARCH({"4*8","8*4","1*5","5*1","5*9","9*5","6*9","9*6"},E2)),"是","不是")

=IF(COUNT(FIND({1,4,5,6,8,9},E2))>1,"是","不是")

白嫖

小白公式。
=IF(IFERROR(FIND("4",E3)*FIND("8",E3),0)>0,"是",IF(IFERROR(FIND("1",E3)*FIND("5",E3),0)>0,"是",IF(IFERROR(FIND("5",E3)*FIND("9",E3),0)>0,"是",IF(IFERROR(FIND("6",E3)*FIND("9",E3),0)>0,"是","不是"))))

白嫖

浮生若梦~~~ 发表于 2024-5-15 16:25
=IF(COUNT(FIND({1,4,5,6,8,9},E2))>1,"是","不是")

这个应该有点问题，比如189，能查找到，但不符合题目要求。