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?
1)
=IF(OR(ISINSET([ERP]@row, "JD Edwards", "Microsoft AX", "Microsoft D365 OnPrem")), "", [Sale Amount]@row * 12) > #UNPARSEABLE
2)
=IFERROR(IF(([Sale Amount]@row * 12), ERP@row, <>"JD Edwards", ERP@row, <>"Microsoft AX", ERP@row, <>"Microsoft D365 OnPrem"), "") > #INCORRECT ARGUMENT
Answers

@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)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!