View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pod pod is offline
external usenet poster
 
Posts: 3
Default 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?