# Is there logical operator "includes any of"?

Topic Labels: Formulas
Solved
3982 2
cancel
Showing results for
Did you mean:
7 - App Architect

Hi, is there a way to compare strings that include same word(or part of the word), but not the whole phrase?

1 Solution

Accepted Solutions
18 - Pluto

You can use the `FIND` or `SEARCH` functions to see if a word is in a phrase. Combine it with the `OR` and `IF` functions to get “includes any of”.

``````IF(
OR(
FIND("keyword 1", {field to search}),
FIND("keyword 2", {field to search}),
FIND("keyword 3", {field to search})
),
"Found at least one",
"Didn't find any"
)
``````

If your {field to search} is a lookup field, you will need to turn it into a string: `{field to search} & ""`

You do have to be careful if some of your keywords are subsets of each other. For example, if you have keywords “alpha” and “alphabet”, this simply formula will find “alpha” even if the field includes only “alphabet”.

2 Replies 2
18 - Pluto

You can use the `FIND` or `SEARCH` functions to see if a word is in a phrase. Combine it with the `OR` and `IF` functions to get “includes any of”.

``````IF(
OR(
FIND("keyword 1", {field to search}),
FIND("keyword 2", {field to search}),
FIND("keyword 3", {field to search})
),
"Found at least one",
"Didn't find any"
)
``````

If your {field to search} is a lookup field, you will need to turn it into a string: `{field to search} & ""`

You do have to be careful if some of your keywords are subsets of each other. For example, if you have keywords “alpha” and “alphabet”, this simply formula will find “alpha” even if the field includes only “alphabet”.

7 - App Architect

Wonderfull, I manage to make it work :slightly_smiling_face: Thanks