IF Statement to set a symbol to a value  #Incorrect Argument set
bday2329
✭✭✭✭
Good Day,
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
Comments

Try removing the comma after the 2nd cell reference...

Thanks Paul..... I will get my eyes checked immediately

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!