IF Statement to set a symbol to a value - #Incorrect Argument set
Options
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
-
Haha. Happens to everyone.
Happy to help though.
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!