IF Statement to set a symbol to a value - #Incorrect Argument set

bday2329
bday2329 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

If statement for Symbols.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!