Issue with ABs + IF formula for RYGG Balls
Hi I am struggling with this formula. I need it to be in absolute values because the variance could be negative. I've tried a couple ways but the RYG balls just stay green no matter the negative value
=IF(ISBLANK(Variance@row), "", IF(Variance@row <= ABS(5000), "Green", IF(Variance@row <= ABS(10000), "Yellow", IF(Variance@row > ABS(10001), "Red", "Grey"))))
Help Article Resources
Check out the Formula Handbook template!