FLOOR.PRECISE Function
Rounds a number down to the nearest multiple, ignoring the sign of significance.
Category
Math & Trig
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice FLOOR.PRECISE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
FLOOR.PRECISE always rounds down (towards negative infinity) to a multiple, whatever the signs.
It matches FLOOR.MATH's default behaviour.
Syntax
=FLOOR.PRECISE(number, [significance])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| significance | Optional | The multiple. Default 1; its sign is ignored. |
Examples
Example 1 — Down, always
Negative numbers move away from zero because that is “down”.
B2fx=FLOOR.PRECISE(A2, 5)
| A | B | |
|---|---|---|
| 1 | Value | Result |
| 2 | 12 | 10 |
| 3 | -12 | -15 |
| 4 | 4.9 | 0 |
=FLOOR.PRECISE(A2, 5) Explain
Common mistakes
- Which one to use? FLOOR.MATH does the same plus a mode for negatives.
Notes
- Related functions: FLOOR.MATH, CEILING.PRECISE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.