VBA uses "Banker's Rounding" (which I think is a term that MS made up),
to round a 5 in the least significant digit to the nearest *even* number
in the next most significant digit.
This method is frequently used in science and statistics. See
http://support.microsoft.com/kb/196652/EN-US/
In article ,
pod wrote:
Rounding in VBA doesn't seem to be consistent. Running the following code
shows that 3.825 rounds down to 3.82, and 3.875 rounds up to 3.88.
MsgBox ("3.825 rounded = " & Round(3.825, 2) & "; 3.875 rounded = " &
Round(3.875, 2))
Is there an explanation for this?