IF Statement

[bthursti]

I am running into problems with an IF statement that includes %'s. I am looking to do an IF statement based on the column YOY FIFO Change - %, if that column number is greater than 50% or less than -50% I would like it to come back with the statement exclude, if less than 50% or less than -50% it would just come back as a null. Can someone take a look at this?

[alexnajm]

There is another file in the workflow that hasn't been included, but if I am just looking at the Formula you need to put "50%" instead of just 50% if it's a string

[alexnajm]

But I'd be careful about referencing a string when you are looking to do numeric conditions - maybe use another column?