FLOOR
Returns a given number rounded down to the nearest multiple of specified significance. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. To round up use CEILING().
Syntax
=FLOOR(Number, Significance)
Arguments
| Name | Type | Description |
|---|---|---|
| Number | Number | The number to round |
| Significance | Number | The multiple to which should be rounded |
Return
| Type | Description |
|---|---|
| Number | The rounded number or an error value. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 4.3 | |
| -46 | |
| -44 |