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

xxxxxxx
Syntax
ISO.CEILING(number,
significance)
 number Required. The value to be
rounded.
 significance Optional. Default =
1. The optional multiple to which number is to be rounded.
(The absolute value of significance is used, allowing the
ISO.CEILING function to return the mathematical ceiling
without regard to the signs of the number and significance.)
Applies To
Excel 2010 and above.
Note: This is a hidden function in many ways. Excel
documentation says that it works only in 2013 and above. But it
actually is recognized in 2010. Additionally, the ISO.CEILING
function was missing from the formula autocomplete system in the
initial versions of 2013.
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.
Remarks
xxx
Examples
xxx
Other ExcelUser
Information
xxx
Other Help

Microsoft Help for the xxx Function
Related Functions
In total,
Excel 2013 offers 15 functions that round data in
various ways. Here's a
summary of Excel's rounding functions.
