Formula to match Payment Terms to a number (Nested If Formula)
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,
Help Article Resources
Check out the Formula Handbook template!