Rounding errors

[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

 

[Frank Kabel]

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