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

Paul Newcome

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

bday2329

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

Paul Newcome

Haha. Happens to everyone.

 

Happy to help though.