The Excel ISO.CEILING function rounds a number up to the nearest multiple of significance, always toward positive infinity — the ISO-standard ceiling that's functionally identical to CEILING.PRECISE.
Syntax
| Argument | Description | |
|---|---|---|
number | Required | The value you want to round up. |
significance | Optional | The multiple to round to. Its sign is ignored. Defaults to 1. |
How to use it
ISO.CEILING always rounds up toward positive infinity and ignores the sign of significance, so mixed signs never cause an error:
For negatives, rounding up means moving toward zero, so -4.3 becomes -4. The result is the same as CEILING.PRECISE in every case.
ISO.CEILING vs CEILING.PRECISE: they return identical results. ISO.CEILING is provided for compatibility with the ISO/ODF spreadsheet standard; pick whichever name reads better in your workbook.
Try it: interactive demo
Pick a ISO.CEILING example to see the formula and its result.
Practice workbook
Frequently asked questions
Is ISO.CEILING the same as CEILING.PRECISE?
significance to 1. ISO.CEILING exists for ISO/ODF compatibility.Why does ISO.CEILING(-4.3) give -4?
Does the sign of significance affect ISO.CEILING?
=ISO.CEILING(23, -5) returns 25, exactly like =ISO.CEILING(23, 5).How does ISO.CEILING differ from classic CEILING?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class