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

ArgumentRequired?What it does
numberYesThe value to round.
significanceOptionalThe 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)
AB
1ValueResult
21210
3-12-15
44.90
=FLOOR.PRECISE(A2, 5) Explain

Common mistakes

  • Which one to use? FLOOR.MATH does the same plus a mode for negatives.

Notes

Kyle Stott

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.