IF Statement to set a symbol to a value - #Incorrect Argument set
I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set
=IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down"))
The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up, Down & Unchanged. See attached.
I can get the following formula to work
=IF([Prev Year Difference]3 < 0, "Down", "Up")
Any help is appreciated!
Thank you in advance
Help Article Resources
Check out the Formula Handbook template!