View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rd rd is offline
external usenet poster
 
Posts: 6
Default Rounding 0.5 to 1

Hi,

I wonder why my VBA code is not rounding 0.5 to 1. The code below produces
zero in the message box instead of the required 1.

Public Sub rwnd()
c = 0.5
MsgBox Round(c, 0)
End Sub

Any help would be appreciated.

Regards,
RD