方法是:
1、首先打开excel,假设我们要判断B列数据是否有包含「百」字的。
![](https://iknow-pic.cdn.bcebos.com/b21bb051f8198618e1a6fffb5aed2e738ad4e6e8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、我们选中D1单元格,然后在公式栏上输入=SEARCH("百",B1)
![](https://iknow-pic.cdn.bcebos.com/0b55b319ebc4b7458b75a769dffc1e178b8215ef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、由于这个单元格没有找到百字,所以返回的是#VALUE!的出错值。
![](https://iknow-pic.cdn.bcebos.com/cc11728b4710b9125b20e681d3fdfc03934522ef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、我们加多一个函数,加上ISNUMBER函数,判断返回的是否是一个数字,是数字则表示包含「百」字,就会显示为true,否则显示为false.
![](https://iknow-pic.cdn.bcebos.com/dc54564e9258d109c302b9cdc158ccbf6d814def?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、然后点击这个结果单元格,点击右下角的小方块往下拉。
![](https://iknow-pic.cdn.bcebos.com/7dd98d1001e9390166e39d416bec54e737d196ef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、使用填充功能,计算下方的结果。
![](https://iknow-pic.cdn.bcebos.com/0df431adcbef760974ea89e03edda3cc7dd99eef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、松开鼠标,就可以得到所有的判断结果了。
![](https://iknow-pic.cdn.bcebos.com/c75c10385343fbf29ccdb65ca07eca8064388fef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)