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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!