https://bugs.documentfoundation.org/show_bug.cgi?id=154792
--- Comment #8 from NOYB <junkyardma...@frontier.com> --- You are talking about internal rounding of calculations. This issue is about the ROUNDDOWN function that is applied to a value per the formula given by the user. If the user want's it rounded down to 2 digits then 0.93 is the correct answer/result for a value of 0.9399999999999995. If the user want's it round up or to nearest 2 digits then 0.94 is the correct answer/result. The rounding functions need to work correctly. Thus producing and exact result of the respective rounding function. Which of these do you reject as not being correct? Round Up: Increment nth digit. Truncate >nth digit. Round Down: Truncate >nth digit. Round Nearest: If nth+1 digit is 5 to 9, increment nth digit. Truncate >nth digit. The point re: digits of precision is that whatever the underlying precision is, whether it be 6, 10, 15, 17, 19, etc. digits, the rounding functions should be accurate. The ROUNDDOWN function for certain is not. Function Wizard ROUNDDOWN( Number, Count ) Rounds a number down to a predefined accuracy. The ROUNDDOWN function does not reliably do what it claims. It is flawed. Period. -- You are receiving this mail because: You are the assignee for the bug.
