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
Best Answer
-
I figured out my own error now. Had an extra comma after the second @row.
Answers
-
I figured out my own error now. Had an extra comma after the second @row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!