IF/OR/AND Statement

Hi I'd like to do a OR statement with 2 and Statements included - following formula is resulting in an error and I can' see why:

=IF(

OR(

AND([Due Time]@row = "EoD", [Needs Removing]@row = 0),

AND(Status@row = "Not Started", Done@row = 0),

"1", "2"))

Can some please take a look over it and advise why and amend.

Many thanks in advance.

Mike

Find more posts tagged with

Accepted answers

Paul Newcome

You forgot to close out your OR statement (and have an extra closing parenthesis on the end of the formula as a result).

=IF(OR(AND(..........), AND(..........)), "1", "2")

All comments

Paul Newcome

You forgot to close out your OR statement (and have an extra closing parenthesis on the end of the formula as a result).

=IF(OR(AND(..........), AND(..........)), "1", "2")

Michael Foster

Parenthesis blind - thanks very much @PaulNewcome that has worked as i'd hoped.

Paul Newcome

Happy to help. 👍️

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.