FLOOR.PRECISE
Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
Math & TrigonometryMath Basics
What it does
Rounds a number down to the nearest integer or multiple of significance.
Syntax
FLOOR.PRECISE(number, [significance])
Arguments
number(number) — Number to round.significance(number) — Multiple.
Examples
Precise Floor
Round 2.5 down to nearest 1.
FORMULA
=FLOOR.PRECISE(2.5, 1)
RESULT
2
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 2.5 |