Multiple Sequences Need to Be Complete/NA to Provide a Complete Value

aeverlyRR2024

Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results.

I am trying to write a formula where I'm looking for sequence values to be either Complete or N/A and based on those sequences being one of those two values, my formula results in reporting a Complete value.

Here are my sequences:

Sequence50

Sequence70

Sequence80

Sequence101

Essentially I'm looking for these sequences to be marked either "Complete" or "N/A" and once all (4) sequences have been marked with either result (complete or N/A) it results in the formula reporting a "Complete" result.

Find more posts tagged with

Formulas

IF(OR

IF(AND

IF(

Accepted answers

aeverlyRR2024

I believe I've got it - all testing is producing the correct outcome.

=IF(AND(OR(Sequence50 = "Complete", Sequence50 = "N/A"), OR(Sequence70 = "Complete", Sequence70 = "N/A"), OR(Sequence80 = "Complete", Sequence80 = "N/A"), OR(Sequence101 = "Complete", Sequence101 = "N/A")), "Complete")

All comments

aeverlyRR2024

I believe I've got it - all testing is producing the correct outcome.

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.