CEILING.PRECISE()
Syntax. CEILING.PRECISE(number,significance)
Definition. This function rounds a number to the next integer or multiple of significance. Regardless of the sign, the value is rounded.
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 CEILING.PRECISE() function allows you to round numbers up to a specified interval limit. Of course, you can get this result with other rounding functions, but CEILING.PRECISE is the direct way.
The CEILING.PRECISE() function uses the absolute value of the multiple and returns the upper limit regardless of the sign of number and significance. The following example shows the difference ...
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.
