Issue with ABs + IF formula for RYGG Balls

Marina Dixon

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"))))

Paul Newcome

Try this...

=IF(ISBLANK(Variance@row), "", IF(ABS(Variance@row) <= 5000, "Green", IF(ABS(Variance@row) <= 10000, "Yellow", IF(ABS(Variance@row) > 10001, "Red", "Grey"))))

Marina Dixon

Thank you!!

Paul Newcome

Happy to help! 👍️