Formula to match Payment Terms to a number (Nested If Formula)

Hello,

I am trying to match a number based on the value of Payment Terms. For example if Payment Terms if NET 30, NET 45, or NET 60 I want to make a formula in a separate column that match the number portion. For example Net 45 should become 45 in a separate column. My formula only seems to work if the Payment Terms is NET 30 and it says #incorrect argument set for other values.

Formula and Screenshot below.

=IF([Payment Terms]@row = "NET 30", 30, IF([Payment Terms]@row, ="NET 45", 45, IF([Payment Terms]@row = "NET 60", 60, "Other")))

Thanks for any help,

Marcel

Find more posts tagged with

Formulas

Accepted answers

Marcel Hovsepian

I figured out my own error now. Had an extra comma after the second @row.

All comments

Marcel Hovsepian

I figured out my own error now. Had an extra comma after the second @row.

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.