rounding numbers

[ybhag]

I would like to know how to round numbers. If the number is greater or equal to then 10028.50 then it should should 10029
thanks

[Dawoodoz]

I dont remember the exact word but i can look it up if you dont have the MSDN discs. "int" is the floor but you wanted the roof if I understand.

[Clay Soyle]

Try this:

Num = 1234.56

Num = Int(Num + 0.5)

Hope this helps,
Clay Soyle

[scripto]

In VB use the Round() function - easier.

[Hemant Pathak]

Hi............. ............... .

Private Sub Command1_Click( )
Dim a As Double
a = 1230.51
Debug.Print Round(a, 0)
Ans=1230
a = 1230.5
Debug.Print Round(a, 0)
Ans=1231
End Sub