ExcelFunctions.net

Excel ISO.CEILING Function

Related Functions:
Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Iso-Ceiling-Function

Basic Description

The Excel Iso.Ceiling function rounds a supplied number up (regardless of the number's sign), to the nearest multiple of a given number.

The function is new in Excel 2010 and so is not available in earlier versions of Excel.

The syntax of the Iso.Ceiling function is:

ISO.CEILING( number, [significance] )

Where the arguments are as follows:

number - The initial number that is to be rounded up
[significance] -

An optional argument that specifies the multiple of significance to round the supplied number up to.

If omitted, the significance argument takes on the default value 1

Note that the arithmetic sign of the [significance] argument is ignored. The supplied number is rounded up for both positive and negative [significance] values.

Iso.Ceiling Function Examples

The following spreadsheet shows the Excel Iso.Ceiling function used with several different significance values, on the positive and negative numbers 22.25 and -22.25.

The functions are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
  A B
1 number iso.ceiling
2 22.25 =ISO.CEILING( A2, 0.1 )
3 22.25 =ISO.CEILING( A3, 0.5 )
4 22.25 =ISO.CEILING( A4, 1 )
5 22.25 =ISO.CEILING( A5 )
6 22.25 =ISO.CEILING( A6, 10 )
7 22.25 =ISO.CEILING( A7, 0 )
8 -22.25 =ISO.CEILING( A8, -0.1 )
9 -22.25 =ISO.CEILING( A9, 0.1 )
10 -22.25 =ISO.CEILING( A10, 5 )
 Results:
  A B
1 number iso.ceiling
2 22.25 22.3
3 22.25 22.5
4 22.25 23
5 22.25 23
6 22.25 30
7 -22.25 0
8 -22.25 -22.2
9 -22.25 -22.2
10 -22.25 -20

The above examples show how:

  • If the [significance] argument is omitted, it takes on the default value of 1.
  • the arithmetic sign of the [significance] argument is ignored - the function gives the same result for both positive and negative [significance] values.
  • if the [significance] argument is zero - the function returns the value 0.
  • the Iso.Ceiling function always rounds the supplied number up. ie. If the supplied number is positive, it is rounded up, away from zero, but if the number is negative it is rounded up, towards zero.

Further information and examples of the Excel Iso.Ceiling function can be found on the Microsoft Office website.


Iso.Ceiling Function Error

If you get an error from the Excel Iso.Ceiling function, this is likely to be the #VALUE! error :

Common Error
#VALUE! - Occurs if one or both of the supplied arguments are non-numeric.