Formula or Tool to search for Variance

[Ethang482]

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 solution]

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!

[Ethang482]

Thank you!