Using the IF and FIND function multiple times

=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", " "))

The above formula works just fine. What I want it to do is look for certain initials and assign different modalities. For example, if the APPT LOCATION starts with "TH" it will assign Teams. So far so good. I also want it to look at APPT LOCATION again and if it starts with "WIC or "NC", then assign VRI. I have tried the following but it gives me #INCORRECT.

=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", " ", IF(FIND("WIC", [APPT LOCATION]@row) > 0, "VRI", " ")))

Any help would be really appreciated.

Mily Oti

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Mily Oti

When you're adding multiple IF statements together, you'll want to "nest" them in a way that says IF this is NOT correct, then check the OTHER IF statement.

This means you'll want to take out the " " at the end of your first statement and go directly into your next IF statement as the value if false, like so:

=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", IF(FIND("WIC", [APPT LOCATION]@row) > 0, "VRI")))

Let me know if this works for you!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Mily Oti

When you're adding multiple IF statements together, you'll want to "nest" them in a way that says IF this is NOT correct, then check the OTHER IF statement.

This means you'll want to take out the " " at the end of your first statement and go directly into your next IF statement as the value if false, like so:

=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", IF(FIND("WIC", [APPT LOCATION]@row) > 0, "VRI")))

Let me know if this works for you!

Cheers,

Genevieve

Mily Oti

Good morning Genevieve,

Thank you so much for the solution; it works perfectly. I appreciate you taking the time to help me out. 🙂

Have a great day!

Mily

Genevieve P.

I'm so glad I could help! 🙂

I hope you have a great day as well.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.