Excel中,某一列数据中包含几个关键字,怎么用函数实现在另一列中显示特 ...答:输入或复制粘贴下列公式之一 =IF(COUNTIF(A1,"*apple*")*COUNTIF(A1,"*MARY*")=1,"MARY LIKES APPLE","")=IF(ISNUMBER(FIND("apple",A1))*ISNUMBER(FIND("MARY",A1))=1,"MARY LIKES APPLE","")=IF(COUNT(FIND("apple",A1))*COUNT(FIND("MARY",A1))=1,"MARY LIKES APPLE",""...