A1=1,8,9,10,20,25,33,38；B

A1=1,8,9,10,20,25,33,38；B1=2;6;12;18;20;25;39;40我想在C1中显示假如A1

1个回答

“1,8,9,10,20,25,33,38”和“2;6;12;18;20;25;39;40”在单元格里面只能被识别为一串字符串或数字的组合,而不能识别为一位数或二位数.
=IF(COUNT(FIND({1,8,9,10,20,25,33,38},B1)),"有","")
显得较为勉强.遗憾!