Excel ISO.CEILING Function

Related Functions:

Excel Rounding Functions

The Excel Iso.Ceiling function is one of fifteen rounding functions in Excel.

A full list, along with comparison tables, is provided on the Excel Rounding Functions page.

Function Description

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

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 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 (i.e. round up to the nearest integer).

Note that the arithmetic sign of the [significance] argument is ignored.

Iso.Ceiling Function Examples

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

Formulas:

	A	B
1	number	iso.ceiling
2	22.25	=ISO.CEILING( A2 )
3	22.25	=ISO.CEILING( A3, 1 )
4	22.25	=ISO.CEILING( A4, 0.1 )
5	22.25	=ISO.CEILING( A5, 10 )
6	-22.25	=ISO.CEILING( A6, 1 )
7	-22.25	=ISO.CEILING( A7, 0.1 )
8	-22.25	=ISO.CEILING( A8, 5 )

Results:

	A	B
1	number	iso.ceiling
2	22.25	23
3	22.25	23
4	22.25	22.3
5	22.25	30
6	-22.25	-22
7	-22.25	-22.2
8	-22.25	-20

The above examples show how:

If the [significance] argument is omitted, it takes on the default value of 1 (see cell B2).
The Iso.Ceiling function always rounds the supplied number up. I.e. If the supplied number is positive, it is rounded up, away from zero, and if the number is negative it is rounded up, towards zero.

For further details and examples of the Excel Iso.Ceiling function, see 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.

Return to the Excel Math Functions Page
Return to the List of All Built-In Excel Functions