FLOOR.MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance.
Math & TrigonometryMath Basics
What it does
Rounds a number down to the nearest integer or multiple of significance, with negative number control.
Syntax
FLOOR.MATH(number, [significance], [mode])
Arguments
number(number) — Number to round.significance(number) — Multiple.mode(number) — Negative direction.
Examples
Floor Math
Round -2.5 down (toward -infinity).
FORMULA
=FLOOR.MATH(-2.5)
RESULT
-3
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | -2.5 |