Should I use IF or IF(AND....or Something Else?

Good afternoon everyone.

I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or "Unparseable". The equations I tried are attached.

Find more posts tagged with

Formulas

functionality

Accepted answers

Danielle Arteaga

Hi, Laurie. I think your issue may be parentheses placement. Try this:

=IF(AND(Open@row = "Closed", Days@row < 30), "Yes", "No")

or try

=IF(AND(Days@row <30, Open@row = "Closed"), "Yes", "No")

All comments

Danielle Arteaga

Hi, Laurie. I think your issue may be parentheses placement. Try this:

=IF(AND(Open@row = "Closed", Days@row < 30), "Yes", "No")

or try

=IF(AND(Days@row <30, Open@row = "Closed"), "Yes", "No")

Laurie Bearden

Thank you so much Danielle! The first formula worked perfectly. 😃

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.