Forum Discussion
Excel Calculation Error?
Quite simply have just come across a "problem" that I am unable to explain.
Entering the formula "101559956668416 * 18" into a cell displays an incorrect result as 1828079220031490.
I am wondering if there is any insight that anyone can offer to explain this apparent error.
I have an example workbook that illustrates this and have incorporated 2 columns of data that make use of addition and multiplication to increment the large base number in the equation by itself. Both sets of data (addition and multiplication) demonstrate the same anomaly. Haven't worked out how to attach that workbook to this post, so am just going to post with the hope that explanation may prompt some feedback.
Technical details: Installed RAM: 8Gb (7.77 Gb usable), System Type: 64-bit operating system, x-64 based processor, Windows 10 Pro, Version 20H2, OS Build 19042-1415, Office 2019 not 365.
Hi, tom_cv11
Excel has a general limit in the number precision of 15 digits. You can find details on general limits and specifications here:
https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
1 Reply
Hi, tom_cv11
Excel has a general limit in the number precision of 15 digits. You can find details on general limits and specifications here:
https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3