請問如何使用EXCEL IF函數搜尋儲存格特定字串?

2016-03-02 6:38 am

例如：如要搜尋A1儲存格中是否含有花、草、葉子、果實等其中一個字串，如果有則利用IF函數分辨為真，則在B1儲存格出現"植物"，反之出現為"非植物"，謝謝

回答 (3)

2016-03-04 1:51 am

.
=IF(SUM(ISNUMBER(FIND({"花","草","葉子","果實"},A1))*1),,"非")&"植物"
或
=IF(SUM(ISERR(FIND({"花","草","葉子","果實"},A1))*1)=4,"非",)&"植物"

👍 0 👎 0

2016-03-02 9:01 am

感謝CJW，果然是高手，真的可行，謝謝

👍 0 👎 0

2016-03-02 8:01 am

=IF(OR(ISNUMBER(FIND("花",A1)),ISNUMBER(FIND("草",A1)),ISNUMBER(FIND("葉子",A1)),ISNUMBER(FIND("果實",A1))),"植物","非植物")

👍 0 👎 0