IF Statement

Question

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?

LIFO.yxmd

LIFO_-_BIR_PTP_016_-_Inventory_On_Hands.xlsx

alexnajm · Answer

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

alexnajm · Answer

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