Math and trigonometry
CEILING.PRECISE Function
Rounds a number up to the nearest integer or multiple of significance. If significance is zero, returns zero.
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

Syntax
CEILING.PRECISE(number,significance)
 number Required. The value to be
rounded.
 significance Optional. The
multiple to which number is to be rounded.
Applies To
Excel 2010 and above
A Note About
"Rounding"
In Excel, numbers can "round" in two ways.
First, they can round up or down. With this type of rounding,
numbers
get larger when they are rounded up, and smaller when they are
rounded down.
Second, numbers can round towards zero or away from zero.
When positive numbers are rounded towards zero, they get
smaller; when negative numbers are rounded towards zero, they get larger.
Although Microsoft uses "round up" and "round down" to
describe both types of rounding, we use "round up" or "round
down" to describe the first type of rounding. And we use "round
towards zero" or "round away from zero" to describe the second
type.
Examples
You can
download this example workbook here,
along with all other example workbooks I've completed for this
Excel help area.
CEILING.PRECISE rounds both positive and negative numbers up. A Significance value of 1 rounds the number up to the nearest integer.
The sign of the Significance value doesn't matter, because
CEILING.PRECISE uses the absolute value of the Significance value.
To illustrate how CEILING.PRECISE works, the "b"
examples show how
using INT can produce the same results as the "a"
examples.
Other Help
Related Functions
In total,
Excel 2013 offers 15 functions that round data in
various ways. Here's a
summary of Excel's rounding functions.
