https://bugs.documentfoundation.org/show_bug.cgi?id=170976
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #3 from Mike Kaganski <[email protected]> --- This is not a wrong result. The formula there returns a value for Row, that is not 1, but ~0.999999999999972: =MOD($A$2*100,100), when applied to "2.01", produces that, because of floating-point calculations (see https://wiki.documentfoundation.org/Faq/Calc/Accuracy). INDEX takes an *integer* as row number [1]; and that means, that any non-integer value will be coerced to integer by truncating (that matches the requirements of the standard [2]). In the end, your formula is equivalent to =INDEX($C$1:$C$99;0) while your intention was =INDEX($C$1:$C$99;1) which needed the formula to be =INDEX($C$1:$C$99;ROUND(MOD($A$2*100;100))) [1] https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#INDEX [2] https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#Conversion_to_Integer -- You are receiving this mail because: You are the assignee for the bug.
