floor
Syntax:
Value
Number
floor
(
Number
num)
Description:
Returns the floor of
num
(the largest integer smaller than
num
).
Examples:
($b1:$b5) = floor($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
0
2
1.99
1
3
-3.7
-4
4
4
4
5
0
0
6
($a1) = floor($f3)