| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does VBA round .5 up or down?
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
