Forum Discussion
tom_cv11
Dec 30, 2021Copper Contributor
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 ...
- Jan 04, 2022
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
Martin_Weiss
Jan 04, 2022Bronze Contributor
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