Forum Discussion
slongazelCU
Jan 14, 2021Copper Contributor
Excel with two digits numbers after decimal has values in the 12th to 16th decimal positions
Hi I recently came across a rounding issue with an excel sheet that was causing problems. We were attempting to move money from one bucket to another, so the total sum from various line items should...
HansVogelaar
Jan 14, 2021MVP
This is due to unavoidable tiny rounding errors. Change the formula in A3 to
=ROUND(A2-A1,2)
See Floating-point arithmetic may give inaccurate results in Excel for some background.