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

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

Find more posts tagged with

Formulas

Support

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.

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.