发布网友 发布时间:2022-04-24 08:08
共5个回答
热心网友 时间:2022-06-17 21:52
如果数据在A2单元格,那么在B2单元格输入:=IF(MAX(IFERROR(FIND({1,2,3,4,5,6,7,8,9,0},A2),))=0,"没有数字","有数字")
亲测可用
热心网友 时间:2022-06-17 21:53
如数据在A1中,在C1中输入公式:=IF(ISERROR(FIND({1,2,3,4,5,6,7,8,9,0},A1)),"没有数字","有数字")热心网友 时间:2022-06-17 21:53
=IF(ISERROR(FIND({1,2,3,4,5,6,7,8,9,0},X)),"没有数字","有数字"),上面老哥这里的X有时候要按F4热心网友 时间:2022-06-17 21:54
=IF(COUNT(FIND({1,2,3,4,5,6,7,8,9,0},A1,1))>=1,"有数字","没有数字")热心网友 时间:2022-06-17 21:54
=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1)),"有数字","没有数字")