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

Marcel Hovsepian

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

Marcel Hovsepian

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

Marcel Hovsepian

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