For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

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, 2005-2014
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.

 

Charley's SwipeFile charts


Free Excel Dashboards