View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Does VBA round .5 up or down?

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?