FLOOR function
The FLOOR function is one of the math and trigonometry functions. It is used to round the number down to the nearest multiple of significance.
Syntax
FLOOR(number, significance)
The FLOOR function has the following arguments:
| Argument | Description |
|---|---|
| number | A number you wish to round down. |
| significance | A multiple of significance you wish to round down to. |
Notes
If the values of x and significance have different signs, the function returns the #NUM! error.
How to apply the FLOOR function.
Examples
The figure below displays the result returned by the FLOOR function.
