https://bugs.documentfoundation.org/show_bug.cgi?id=172117
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #2 from ady <[email protected]> --- (In reply to helvix from comment #0) > Description: > I tried: > =REDONDEAR.MENOS(-5.89) > =TRUNCAR(-5.89) > > Both are the same -5, in "=REDONDEAR.MENOS(-5.89)" It must be -6 No, it is -5. Unfortunately, the name of the function is somewhat misleading. ROWNDDOWN rounds towards ZERO, even for negative values. If you want to round towards negative infinity, there are several FLOOR functions. -- You are receiving this mail because: You are the assignee for the bug.
