excel search函数_search函数

2023-03-31 05:41:32 来源:互联网


(资料图)

1、=IF(ISERR(FIND("临汾",A1)),"外市","本市")或=IF(COUNT(FIND("临汾",A1)),"本市","外市") =IF(ISERR(SEARCH("临汾",A1)),"外市","本市") =IF(COUNT(SEARCH("临汾",A1)),"本市","外市")。

本文就为大家分享到这里,希望小伙伴们会喜欢。

推荐阅读>