(资料图)
1、=IF(ISERR(FIND("临汾",A1)),"外市","本市")或=IF(COUNT(FIND("临汾",A1)),"本市","外市") =IF(ISERR(SEARCH("临汾",A1)),"外市","本市") =IF(COUNT(SEARCH("临汾",A1)),"本市","外市")。
本文就为大家分享到这里,希望小伙伴们会喜欢。