Contains Formula
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?
ie)
=IF(CONTAINS("Apple" or "Orange", Fruit1:Test1), "Fruit")
or something along those lines?
Tags:
Best Answer
-
=IF(or(CONTAINS("Orange", Fruit1:Test1),CONTAINS("Apple", Fruit1:Test1)), "Fruit"
you could write it out like this
Answers
-
=IF(or(CONTAINS("Orange", Fruit1:Test1),CONTAINS("Apple", Fruit1:Test1)), "Fruit"
you could write it out like this
-
@L@123 That worked great, thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!