Simple Variance Formula, but wrong?
I'm trying to use this below formula for a direction column, but getting UNPARSEABLE. Seemed pretty straightforward to me. I have a similar formula that is working for RAG column.
=IF([Variance]@row < 0, "Down”, “Up”) IF([Variance]@row > 0, “Up”, "Unchanged"))
Help Article Resources
Check out the Formula Handbook template!