IF Statement Question

I am trying to get a formula to multiply [Sale Amount] by 12 if ERP is not JD Edwards, Microsoft AX, or Microsoft D365 OnPrem; otherwise, leave it blank...

I have tried the following formulas (with their corresponding error messages).

Is there an alternate formula I can use?

=IF(OR(ISINSET([ERP]@row, "JD Edwards", "Microsoft AX", "Microsoft D365 OnPrem")), "", [Sale Amount]@row * 12) -> #UNPARSEABLE

=IFERROR(IF(([Sale Amount]@row * 12), ERP@row, <>"JD Edwards", ERP@row, <>"Microsoft AX", ERP@row, <>"Microsoft D365 OnPrem"), "") -> #INCORRECT ARGUMENT

Find more posts tagged with

Accepted answers

All comments

JamesB

@amy.cooper This should work for you. IF ERP is one of the 3 variables, then blank. If it is not one of the three then take the Sales Amount *12.

=IF(OR(ERP@row = "JD Edwards", ERP@row = "Microsoft AX", ERP@row = "Microsoft D365 OnPrem"), "", [Sale Amount]@row * 12)

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.