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.
Printable View
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.
Code:Mynum = 475.413
NyNewNum = CInt(Mynum)
MsgBox(MyNewNum)
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.