FLOOR.PRECISE()
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
number (required) The value you want to round.
significance (optional) The multiple to which you want to round. The default value for significance is 1.
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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
