Excel FLOOR.PRECISE Function

Using the Excel FLOOR.PRECISE Function


The FLOOR.PRECISE function rounds a given number down to the nearest integer or user specified level of significance. Regardless of the number's sign, it is always rounded down. If you are trying to round to the nearest multiple, either up or down, the MROUND function can be used.


=FLOOR.PRECISE (number, [significance])

Syntax Breakdown

The number argument is required in the FLOOR.PRECISE function. This is the value that you wish to round down.

Significance is optional and is the user specified multiple that number should be rounded down to. If significance isn't defined, the default value is 1. If significance is entered as 0 the function will return 0.

Usage Notes

The FLOOR.PRECISE function is used to round a number down to the nearest integer. The function always rounds the number argument down. When dealing with decimals, positive numbers will round down to the nearest integer and negative numbers will always round away from zero. For example, 5.5 would round down to 5 and -5.5 would round to -6. If you require control over how negative numbers are rounded, the FLOOR.MATH function can be used.

Compared to FLOOR
FLOOR.PRECISE differs from FLOOR in a few ways:
  • FLOOR.PRECISE always defaults to a multiple of 1 when rounding.
  • FLOOR.PRECISE always rounds negative numbers away from zero.
  • FLOOR.PRECISE does not consider the sign of the significance argument and only uses the absolute value.