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.
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:
Where the arguments are as follows:
|number||-||The number that is to be rounded up|
|[significance]||-||[significance] argument is ignored.The arithmetic sign of the|
In the following spreadsheet, the Excel Iso.Ceiling function is used to round the positive and negative numbers 22.25 and -22.25 to different significance values.
The above examples show how:
Further information and examples of the Excel Iso.Ceiling function can be found on the Microsoft Office website.
If you get an error from the Excel Iso.Ceiling function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if one or both of the supplied arguments are non-numeric.|