Description: I try to generate random numbers and I need to evaluate a small decimal part of my numbers. I do a int((A1-int(A1))*60) on random numbers with one digit But in some cases, when my number's decimal part seems to be 1, I've got an unespected result Steps to Reproduce: 1. in A1 =(RANDBETWEEN(1;9)*10+1)/10 2. in B1 =INT((A1-INT(A1))*60) Actual Results: the result in B1 should be 6, but in some cases is 5 Type F9 to change the values. Expected Results: always 6 Reproducible: Sometimes User Profile Reset: No Additional Info: With other decimal numbers than 1, there's no problem
FAQ: https://wiki.documentfoundation.org/Faq/Calc/Accuracy 0.1 is not representable in binary. If binary representation a number 'x.1' happens to be slightly greater than x.1 (something like x.1000000000000012412), then you will have 6; if it happens to be slightly smaller (like x.0999999999999998712), you get 5.
Ok, got it
*** This bug has been marked as a duplicate of bug 63242 ***