Select ceiling figure in Rounding method

[trisLOGIC]

Is there a function that return the ceiling value from a decimal value. The Round function in VB will round it to its closest value (which is not what i want). Thanks.

What do you mean by ceiling value? You could use the CInt Function to round a number.

Mynum = 475.413
NyNewNum = CInt(Mynum)
MsgBox(MyNewNum)

[trisLOGIC]

What I want is -

val = 4.1

after process -
val = 5


Using the round function or cint will make 4.1 become 4 but what I want is if the 4 value is pass, no matter after 4.5 or before, I want to figure to become 5.