Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Round to .05 or .09 | Excel Worksheet Functions | |||
Round up | Excel Discussion (Misc queries) | |||
VBA round | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |