Author: Oscar Cronquist Article last updated on October 01, 2018

The FLOOR.PRECISE function rounds a number down to the nearest integer or nearest multiple of significance.

Excel Function Syntax

FLOOR.PRECISE(number, [significance])


number Required.
[significance] Optional, the number is rounded down to the given multiple. The default value is 1.


The sign of the number does not determine if the number is rounded down, see image above.

The FLOOR.PRECISE function returns 0 (zero) if number or [significance] is zero.