There is also:
When the fractional part is exactly 0.5, CInt and CLng always round it to the nearest even number. For example, 0.5 rounds to 0, and 1.5 rounds to 2. CInt and CLng differ from the Fix and Int functions, which truncate, rather than round, the fractional part of a number. Also, Fix and Int always return a value of the same type as is passed in.
Or You can use:
- If Val(Text1) > Int(Val(Text1)) Then
-
Text_roundup = Int(Val(Text1)) + 1
-
Else
-
Text_roundup = Int(Val(Text1))
-
End If