FLOOR(number, significance)
- Where 'number' is the numeric value to round and
- significance' is the multiple to round the number.
FLOOR() rounds the number down towards zero, to its nearest multiple of significance.
Description
FLOOR(number, significance)
For Example, FLOOR (3.5, 2) is 2
- Calci returns an error value when argument is nonnumeric.
- Calci returns an error message if 'number' and 'significance' have different signs.
- If the number is an exact multiple of significance, rounding will not be done. Calci will display the same number as output.
Examples
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 3.5 | 2 | ||
| Row2 | 2 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |