Nesting OR into AND?

Hi All,

I'm wondering if it is possible to nest an "OR" statement into an "AND" statement. In short, Task C requires Task A be "complete" and Task B be one of two statuses.

I'd expect it to work something like this (note, I'm using status names to illustrate the point): =IF(AND(StatusA="Complete", OR(StatusB="In Progress", StatusB="Complete")), "In Progress", "Not Started")

This is throwing errors, though. Is there a trick I'm not getting, or

Any help would be greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

All comments

Werner Gerstacker

It looks fine to me - as long as you have your @row reference in there you should be fine:

=IF(AND(StatusA@row ="Complete", OR(StatusB@row ="In Progress", StatusB@row ="Complete")), "In Progress", "Not Started")

Paul Newcome

You're actually very close. You only need to include a row number or "@row" reference.

=IF(AND(StatusA@row="Complete", OR(StatusB@row="In Progress", StatusB@row="Complete")), "In Progress", "Not Started")

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.