求修改公式，谢谢~~~~~~~~~~~~~~~~~~~~~~~~~~~

朋友多了路好走

目前公式是：=IF(ISERROR(FIND("YFD",A1)),"否","是")
期望实现：A1列为空白的时候，B1列也是空白（黄色部分为空白）

用户海阔天空

=IF(A1="","",IF(ISERROR(FIND("YFD",A1)),"否","是"))

朝这里飞

IF(A1="","",IF(COUNTIF(A1,"*YFD*"),"是","否"))

国防教育

FIND函数，我改成SEARCH函数了，感谢~
=IF(N8="","",IF(ISERROR(SEARCH("YFD",N8)),"否","是"))