Manuals/calci/FLOOR
Jump to navigation
Jump to search
Syntax
Remarks
Examples
''''''' ''''
Description
FLOOR
FLOOR (N, Signi)
Where N is the numeric value and Signi is the multiple to round up.
· FLOOR returns an error value when argument is nonnumeric or N and Signi have different signs.
· If the number is an exact multiple of significance, no rounding will occur.
.
Floor rounds the numbers down to the nearest multiple of significance.
Lets see an example in (Column1, Row 1)
FLOOR
FLOOR (C1R1, C2R1))'
That is FLOOR (3.5, 2) is 2
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3.5 | 2 | ||
| Row2 | 2 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
