Formula based on a symbol column
I have a symbol column and want to add a score in another column based on the symbol. I am currently using the following formula but am getting an #INCORRECT ARGUMENT error.
=IF([Risk Management]@row, "Up", 3, IF([Risk Management]@row, "Unchanged", 2), IF([Risk Management]@row, "Down", 1))
I've solved it myself now. :-)
Help Article Resources
Check out the Formula Handbook template!