Issue with ABS function within if statement

Options

I've got a very specific problem with an ABS function nested in an IF function. My formula is basically: IF(ABS(X-Y) <= 0.1,"","Out"). As far as I can tell the formula functions correctly, EXCEPT when X and Y are both values from 7.30 to 7.49. In this instance, if ABS(X-Y)=0.1, then it returns "Out".

Ex. when X=7.44 and Y=7.34, the formula returns "Out". It does the same if the X and Y values are swapped.

Ex. when X=7.50 and Y=7.40, the formula returns "". It does the same if the X and Y values are swapped.

There may be another range that malfunctions, but I haven't found one yet. Any thoughts on what could be going on here? Thanks for your help!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!