Rounding numbers

gr · Jul 16, 2004

Hello, does someone knows how I can round a number always
to the upper value?

example:
I have I want
1.23 2
1.5 2
1.8 2
0.1 1
3.76 4

Thx!

Allen Browne · Jul 16, 2004

Assuming the numbers are all positive, you could use the fact that Int()
always rounds downwards:
-Int(-[MyField])