Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
FLOOR.PRECISE
Rounds a number down to the nearest multiple of significance, always toward negative infinity regardless of sign.
Rarely usedDifficulty 1200 · ProficientUsage rank #263 of 520
When to use it
Rounds down toward negative infinity to a multiple of significance, ignoring the sign of significance.
The shape of it
- Syntax
=FLOOR.PRECISE(number, [significance])
Worked examples
Whole number
=FLOOR.PRECISE(4.7) → 4
Whole number.
Negative input
=FLOOR.PRECISE(-4.3) → -5
Toward negative infinity.
Multiple
=FLOOR.PRECISE(23,5) → 20
Multiple of 5.
Worth knowing
- FLOOR.MATH with mode 0 is the same thing under the current name.
- Negative significance is treated as positive.
- Significance defaults to 1.
Where it goes wrong
- Not in Excel 2007 or earlier.
- Differs from FLOOR for negative numbers.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.