IF Formula

My goal is to return two potential values depending on what is selected in a multi-select column (Named: [VA...DBQ Worksheet] ).

The dropdowns are:

Service Connected Diagnosis Blank

Service Connected Diagnosis Incomplete (Rated as vs. Contention Name)

Bilateral Indicator

ICD Code

If any of the first three are selected I want the result to return as "Miss". If the ICD Code dropdown is the only thing selected, I want it to return "On Target". If nothing is selected, just return blank.

I'm thinking it would be some form of a nested IF and OR formula? My brain is stuck.

Find more posts tagged with

Formulas

Accepted answers

All comments

TVang

Hi, @Brittany Johnson , you would use a nested IF() formula. IF(NN="", "", IF( NN="ICD Code", "On Target", "Miss")).

=IF([multi-select column]@row = "", "", IF([multi-select column]@row = "ICD CODE", "On Target", "Miss"))

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.