Excel vs Access Rounding

[Guest]

Excel rounds the sum of the folloing 10 numbers as 81.06

8.17
8.25
7.00
8.33
8.50
8.33
8.27
7.58
8.55
8.08

Access rounds it as 81.07 Can this be fixed to match?

 

[Steve Schapel]

Jonefer,

On the basis of the numbers you have given, there is no rounding. All
the numbers show 2 decimal places, and the total is 2 decimal places.
Therefore, I assume that the figures shown are the result of formatting
to 2 decimal places, and that the actual values being added are
different. It depends a bit what you really want. Are the figures
being added the result of calculations? You could consider the idea of
rounding the figures to 2 decimal places before adding them.