Forum Discussion
Florin2185
Jan 16, 2022Copper Contributor
Strange result in Excel
I obtained a strange result in a simple Excel worksheet. Can you explain it?
HansVogelaar
Jan 16, 2022MVP
This is a result of the way Excel handles numbers - see Floating-point arithmetic may give inaccurate results in Excel
The solution is to use the ROUND function.
The numbers used in your calculation have at most 2 decimal places, so you should round the result of the formula to 2 decimal places too: change
=expression
to
=ROUND(expression,2)