Merging Two Columns

[cwigert]

Hello,

I am trying to replace the data in column Price with $420 but only if Price2 is $420. Currently, my formula makes Price equal to $0, not $420. Not sure what is wrong with my IF statement, maybe there is a different tool I should be using? Any ideas are helpful.

[cmcclellan · Accepted solution]

I think your code should be

If ToNumber([Price2]) > 0

then 420

else [Price]

endif