Mod(2.01,int(2.01))=0.01 returns false
Hi @Brian, thanks for reporting.
Really not a bug, but a hardware limitation, please take a look to https://bugs.freedesktop.org/show_bug.cgi?id=50299#c4.
Another symptom of floating-point arithmetic being imperfect.
If you bump-up precision to 20 places, you see:
MOD(Value, INT(Value)): 0.00999999999999979000
When you compare 0.01000000000000000000 and 0.00999999999999979000, Calc (correctly) says that they're not the same.
I'm not sure if Calc has a built-in EQUAL_WITHIN_TOLERANCE() function, but you can use this for the purpose:
=(ABS($CELL_OF_FIRST_VALUE - $CELL_OF_SECOND_VALUE) < 0.0000000000001)
Making sure that two values are less than 1e-12 different should be close enough for most purposes :-)
Bug 67026 - Other: Limitations in Calc precision need to be documented