Why am I getting an #INCORRECT ARGUMENT error when conditions meet the last IF/AND statement?

=IF([Deadline for implementing this project]@row - [Submission Date]@row < 30, 3, IF([Deadline for implementing this project]@row - [Submission Date]@row > 60, 1, IF(AND([Deadline for implementing this project]@row - [Submission Date]@row <= 60, [Deadline for implementing this project]@row - [Submission Date]@row >= 30, 2))))

I get the error for when rows' [Deadline for implementing this project] - [Submission Date] is greater than 30 but less than 60.

Find more posts tagged with

Accepted answers

KPH

It looks like the closing parenthesis for the AND is in the wrong place:

Instead of

Try

As the IFs are nested in the value_if_false position they are only evaluated if the previous one is false. Your first IF returns 3 for gaps* less than 30. The second is evaluated only if the gap is 30 or more. If turns 1 is the gap is more than 60. So the third IF is only evaluated if the gap is 30 or more and less than 60. So you don't really need the third IF or the AND. This would do the same

=IF([Deadline for implementing this project]@row - [Submission Date]@row < 30, 3, IF([Deadline for implementing this project]@row - [Submission Date]@row > 60, 1, 2))

*I am referring to days between "Deadline for implementing the project" and "Submission Date" as a "gap" as it is a lot shorter!

All comments

KPH

It looks like the closing parenthesis for the AND is in the wrong place:

Instead of

Try

=IF([Deadline for implementing this project]@row - [Submission Date]@row < 30, 3, IF([Deadline for implementing this project]@row - [Submission Date]@row > 60, 1, 2))

*I am referring to days between "Deadline for implementing the project" and "Submission Date" as a "gap" as it is a lot shorter!

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.