Contains Formula

Jen Evans

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?

L_123

=IF(or(CONTAINS("Orange", Fruit1:Test1),CONTAINS("Apple", Fruit1:Test1)), "Fruit"

you could write it out like this

L_123

=IF(or(CONTAINS("Orange", Fruit1:Test1),CONTAINS("Apple", Fruit1:Test1)), "Fruit"

you could write it out like this

Jen Evans

@L@123 That worked great, thank you!