# Formula with IF and FIND

#1

I’ve read through this post and just can’t understand how the FIND and IF formulas work together – and there is no documentation on Airtable for formulas, other than their definitions.

What I really need is:

• IF the column “Associate” CONTAINS “Person A” OR “Person B” OR “Person C” – AND if the column “Principal” has the value of "Yes – to then display the number 5.

• The “Associate” column can contain multiple people in one record, so an IF formula won’t work.

• If “Associate” includes any of those Persons BUT the “Principal” column does NOT have value “Yes,” then the returned value is 0.

I have been wrestling with this for a long time but feel the solution is simple. Please advise!

Javier

#2

Try this:

``````IF(
OR(
FIND(
"Person A", {Associate}
),
FIND(
"Person B", {Associate}
),
FIND(
"Person C", {Associate}
)
),
IF(
{Principal} = "Yes",
5,
0
)
)
``````

I’m sure this won’t take into account other things you might need it to do (like what to return if none of those “Persons” is found in “Associate”) - but try this first, and if it does the main thing you need it to we can refine it more based on your response.

#3

Exactly what I was looking for. Makes sense. Thanks so much!