Does VBA round .5 up or down?

[Guest]

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?

 

[JE McGimpsey]

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/