FLOOR.PRECISE function

1 year ago

2 minutes

The FLOOR.PRECISE function in Excel is used to round a number down to the nearest multiple of a specified significance, always rounding away from zero. Unlike the FLOOR and FLOOR.MATH functions, FLOOR.PRECISE always rounds negative numbers away from zero, providing a consistent rounding method, regardless of the sign of the number.

Syntax

=FLOOR.PRECISE(number, significance)

Parameters

number: The number you want to round down.
significance: The multiple to which you want to round the number. This value must be positive.

Return Value

The function returns a number rounded down to the nearest multiple of the specified significance, always rounding away from zero, even for negative numbers.

Example 1: Round Down to the Nearest Multiple of 5

To round 12 down to the nearest multiple of 5:

=FLOOR.PRECISE(12, 5)

Result: 10
Explanation: The nearest multiple of 5 less than or equal to 12 is 10.

Example 2: Round Down to the Nearest Multiple of 0.5

To round 7.3 down to the nearest multiple of 0.5:

=FLOOR.PRECISE(7.3, 0.5)

Result: 7.0
Explanation: The nearest multiple of 0.5 less than or equal to 7.3 is 7.0.

Example 3: Round Negative Number Away from Zero

To round -7.5 down to the nearest multiple of 2:

=FLOOR.PRECISE(-7.5, 2)

Result: -8.0
Explanation: Since FLOOR.PRECISE always rounds away from zero, it rounds -7.5 to -8.0 (rather than towards negative infinity, as in the older FLOOR function).

Key Characteristics of FLOOR.PRECISE

FLOOR.PRECISE rounds numbers away from zero, so it does not depend on whether the number is positive or negative.
Unlike the FLOOR.MATH function, FLOOR.PRECISE does not offer a mode argument to control how negative numbers are handled—it always rounds away from zero.
The significance parameter must be positive, otherwise Excel will return an #NUM! error.
It is available in Excel 2013 and later versions.

Example in Practice

When you need to round numbers consistently in one direction (away from zero), FLOOR.PRECISE is a reliable option, especially in financial calculations where this behavior is required for both positive and negative numbers.

For instance, if you want to round down a price (e.g., $3.75) to the nearest multiple of 0.5:

=FLOOR.PRECISE(3.75, 0.5)

Result: 3.5
Explanation: FLOOR.PRECISE rounds 3.75 down to 3.5, the nearest multiple of 0.5.

This behavior ensures consistency across positive and negative values when rounding is needed.

Post Views: 15