round function

[R LAWSON]

Hello
can anyone tell me if the result of a calculation returns a value of say 62.05 (could be anything)is it possible to use the round function to make the result always round up eg:63 rather than 62?
Thanks

[oetje]

Why not do this?

Rounded = Int(Number + 1)

One way to always make a real value round up is to use the Int() function (which always rounds down on positive numbers) and just add one to your result. For example:

Dim dblNumber As Double
Dim intResult As Integer

dblNumber = 62.05

intResult = Int(dblNumber) + 1

MsgBox intResult  '  Displays 63

Paul

PS - Looks like oetje and I posted the same reply at the same time! :P

[HeSaidJoe]

Something to be aware of if you are wanting to
keep the whole number and disregard the .xx

Dim x as double
x = 62.65   'if .xx more than .5x

msgbox round(x) + 1 'returns 64
msgbox cint(x) + 1  'returns 64
msgbox fix(x) + 1   'returns 63

fix always reverts to the whold while cint,round, will
go higher if fraction over 5