Rounding errors

  • Thread starter Thread starter Dale Brown
  • Start date Start date
D

Dale Brown

Hi everyone;
This has probably been asked numerous times but I can't find my answer so
far.
What does it take to make my simple additions to add properly?
Calculated amounts sometimes will round to the wrong amount and the results
will
be off. ex: 5.12 + 5.12 + 3.14 = 13.37? Why is this?
Thanks for the help.
Dale
 
Hi Dale

are the values 5.12, etc calculated by other formulas? If yes then -
depending on your chosen cell format - they are shown with only two
decimals. Though internally are calculated with their exact value. So
the processed by the next formula (e.g. SUM) these 'rounding' errors
could appear).
e.g. cell format is 0.00 (2 decimals)
Display Internal value
5.12 5.116
5.12 5.116
3.14 3.14

SUM:
13.37 13.372

If you want to change this behaviour you have to round the values which
are created by formulas

HTH
Frank
 
Back
Top