Forum Discussion
Incorrect 15th decimal causing rounding errors
I have a spreadsheet to create Golf Handicap Tables. The first column ranges from +5.0 to 54.0 in steps of 0.1 for a total of 591 rows. The column is displayed to 1 decimal. But if the same valu...
This is a question that has been asked many times before. See this article:
https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result