View Full Version : rounding up

03-23-2004, 06:45 PM
is there any way to round UP (fix and int round down) that isnt just 1 of fix+1, int+1 or round+0.5 because they all return 1 for 0, 2 for 1 etc i think round+0.4999999 pay work but i dont know and if there is a better ceiling function i would prefer to use that

03-23-2004, 06:49 PM
i suppose i could do

if int(number) <> number then number = int(number)+1
and take the variable called number out of that

03-23-2004, 10:53 PM
Same thing but in a function....

Function Ceil(n)
If (n = Int(n)) Then
Ceil = n
Ceil = Int(n+1)
End If
End Function