This function rounds a number down to the nearest multiple of the specified value.
FLOOR.MATH(value,signif,mode)
This function has the following arguments:
| Argument | Description |
|---|---|
| value | Number to round |
| signif | [Optional] Number representing the rounding factor |
| mode | [Optional] Represents the direction (towards or away from 0) to round negative value |
Positive numbers with decimal parts are rounded down to the nearest integer.
Negative numbers with decimal parts are rounded away from 0 to the nearest integer.
Accepts numeric data for both arguments. Returns numeric data.
FLOOR.MATH(-3.1,3,4) gives the result -3
FLOOR.MATH(-6.3,8) gives the result -8
This function is available in Spread for Windows Forms 11.0 or later.