ceil
Syntax:
Value
Number
ceil
(
Number
num)
Description:
Returns the ceiling of
num
(the smallest integer larger than
num
).
Examples:
($b1:$b5) = ceil($a)
Before:
A
B
C
1
0.34
2
1.99
3
-3.7
4
4
5
0
6
After:
A
B
C
1
0.34
1
2
1.99
2
3
-3.7
-3
4
4
4
5
0
0
6
($a1) = ceil($f3)