Syntax. FLOOR.PRECISE(number,significance)

Definition. This function rounds a number down to the next integer or multiple of significance. The value is rounded down the same way regardless of the sign. The function returns 0 if number or significance is zero.

Arguments

Background. The FLOOR.PRECISE() function allows you to round numbers to a specified interval limit. Of course you could use the other rounding functions in different formulas, but FLOOR.PRECISE() is the fastest method.

The FLOOR.PRECISE() function uses the absolute value of the multiple and returns the lower limit regardless of the sign of number and significance.

The following example shows the difference between FLOOR() and FLOOR.PRECISE():

FLOOR(-3.2,-1) = -3

FLOOR.PRECISE(-3.2,-1) = -4

The FLOOR.PRECISE() function rounds the negative number (–3.2) down to the absolute value, whereas the FLOOR() function rounds a number with a negative sign up. The difference between FLOOR.PRECISE() and FLOOR() is that FLOOR.PRECISE() rounds a number with a negative sign down.

Example. A wholesaler can order a minimum of five bicycles from a bicycle manufacturer. As soon as the stock falls below zero, an order has to be placed. The stock can be below zero if no bicycles are in stock and retailers order bicycles. If the stock is –6, then six bicycles are ordered. Therefore, the order is FLOOR.PRECISE(-6,-5) = -10 or ABS(-10) = 10 bicycles. You can combine the two formulas:

=ABS(FLOOR.PRECISE(-6,-5))