Formula or Tool to search for Variance

Question

I'm looking to solve an issue where I have a column with YoY% variances. The end goal is to find those whose variance is +/-15% within a row to then produce the word "Error" to structure conditional formatting in excel.

Currently the Var% as Double type and think that could be the problem in the below formula and might need to change one way or the other:

IF [YoY Var%] > ABS(15) then "ERROR" elseif "GOOD" ENDIF

Everything works in the formula except the 'ENDIF'

jmgross72 · Accepted Answer

Use this formula instead:

IF [YoY Var%] > ABS(15) then "ERROR" else "GOOD" ENDIF

The difference being elseif > else.  You only need to use elseif if there is another condition you want to test.  For the default output, else is the way to go.

Hope this helps!