Combined IF, AND, & OR Statments

I am having trouble with a combined IF, AND, & OR formula. The formula is to check five columns for a Yes "Y" value. For two of the columns only one value has to be Yes. If all are true then return a 1, if not then return a 0. Where is my formatting wrong?

=IF(AND([SPC Received]@row = "Y", OR([SDS Received]@row = "Y", [Shelf Life Received]@row = "Y"), [Code Received]@row = "Y", [Code Created]@row = "Y") = true, 1, 0)

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@Luke S.

You don't need the '= true' part of your formula

=IF(AND([SPC Received]@row = "Y", OR([SDS Received]@row = "Y", [Shelf Life Received]@row = "Y"), [Code Received]@row = "Y", [Code Created]@row = "Y"), 1, 0)

Luke S.

@Leibel Shuchat

Thanks so much, I removed the '=True', and it worked.

All comments

Mike TV

@Luke S.

The problem with this formula is that you put the OR statement in the middle of the AND statement. I don't believe those two can be used with each other. For example, you can't do =IF(AND(OR(logic) and you can't thread the OR in the AND statement until the AND is closed out and another IF is begun.

If you write out which columns need a "Y" to return a "1" and which need 2 columns with "Y" to return a "1" etc, then I can help you write the formula.

Leibel S

@Luke S.

You don't need the '= true' part of your formula

=IF(AND([SPC Received]@row = "Y", OR([SDS Received]@row = "Y", [Shelf Life Received]@row = "Y"), [Code Received]@row = "Y", [Code Created]@row = "Y"), 1, 0)

Luke S.

@Leibel Shuchat

Thanks so much, I removed the '=True', and it worked.

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.