Syntax
FLOOR.MATH(number, [significance], [mode])
| Parameter | Description |
|---|---|
| number | Parameter of the FLOOR.MATH function. |
| [significance] | (Optional.) Parameter of the FLOOR.MATH function. |
| [mode] | (Optional.) Parameter of the FLOOR.MATH function. |
Examples
Round down to integer
Formula
=FLOOR.MATH(5.7)
Returns 5. With no significance specified, it rounds down to the nearest integer.
Negative number, default mode
Formula
=FLOOR.MATH(-4.3, 2)
Returns -6. By default, FLOOR.MATH rounds negative numbers away from zero (more negative).
Negative number, toward zero
Formula
=FLOOR.MATH(-4.3, 2, 1)
Returns -4. With mode=1, negative numbers round toward zero instead.
Common Errors
#VALUE!
Non-numeric arguments produce this error. All parameters must be numbers.
#DIV/0!
A significance of 0 causes #DIV/0! since it would require dividing by zero.
Tips
Preferred over FLOOR
FLOOR.MATH doesn't error on mixed-sign arguments like FLOOR does. Use it as your default floor-rounding function.
Mode only affects negatives
The mode parameter is ignored for positive numbers. It only changes behavior when the number is negative.
Default significance is 1
If you omit the significance, it defaults to 1, making FLOOR.MATH(x) equivalent to INT(x) for positive numbers.
Try FLOOR.MATH in Viztab
Import your data and use FLOOR.MATH with 370+ other formulas. No signup required.
Open Viztab