I currently have a formula that looks to see if a specific phrase is contained within a range of cells:
=IF(CONTAINS("Apple", Fruit1:Test1), "Fruit")
Is there a way to have the formula look for another phrase as well?
=IF(CONTAINS("Apple" or "Orange", Fruit1:Test1), "Fruit")
or something along those lines?
Help Article Resources
Check out the Formula Handbook template!