The Excel FLOOR.PRECISE function rounds a number down to the nearest multiple of significance, always toward negative infinity, ignoring the sign of significance.
Syntax
| Argument | Description | |
|---|---|---|
number | Required | The value you want to round down. |
significance | Optional | The multiple to round to. Its sign is ignored. Defaults to 1. |
How to use it
FLOOR.PRECISE always rounds down toward negative infinity and ignores the sign of significance, so mixed signs never cause an error:
For negatives, “down” means away from zero, so -4.3 becomes -5. It is the down-rounding counterpart of CEILING.PRECISE.
Significance sign is ignored. Unlike classic FLOOR, =FLOOR.PRECISE(23, -5) still returns 20 — the negative sign on significance is simply discarded.
Try it: interactive demo
Pick a FLOOR.PRECISE example to see the formula and its result.
Practice workbook
Frequently asked questions
How is FLOOR.PRECISE different from FLOOR?
significance, so it never errors on mixed signs. Classic FLOOR does.Why does FLOOR.PRECISE(-4.3) give -5?
Does the sign of significance matter?
=FLOOR.PRECISE(23, -5) returns 20, the same as =FLOOR.PRECISE(23, 5).Is FLOOR.PRECISE the same as INT?
=FLOOR.PRECISE(-4.3) and =INT(-4.3) return -5, rounding toward negative infinity.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class