Round Function Problem

  • Thread starter Thread starter Anatoly Kurilin
  • Start date Start date
A

Anatoly Kurilin

Hi, the function Round in Microsoft Access returns 66.22 = Round(66.225, 2),
but the same function in Microsoft Excel returns 66.23. I'm really
embarrassed! What number is correct?



Thank in advance,

AK
 
Dear Allen, thanks for the tip. Is it possible to make Microsoft Excel and
Access Round functions to return the same rounded number?

AK
 
It depends how the number is represented internally.

In Access you can use a fixed-point number (such as Currency) or a scaled
number (such as Decimal) if you want precision, but remember that the
Round() function in Access uses bankers rounding.

In Excel, you typically have less control over the data type (though you
could typecast), so I can't guarantee you the same results. The Round() in
Excel and in Access are quite different. For example, in Excel it works with
a negative number of decimal places (2nd argument), but this won't work at
all in Access.
 
Back
Top