How to use ISO.CEILING function in Excel?

The `ISO.CEILING` function in Excel is used to round numbers up towards zero to the nearest multiple of a specified significance. This function is particularly useful for financial and engineering applications where standard rounding conventions are required.

Here is the syntax for the `ISO.CEILING` function:

ISO.CEILING(number, [significance])

number: This is the numeric value that you want to round up.
significance: This is the multiple to which you want to round. The default significance is 1 if this argument is omitted.

Example Usage

Round a number to the nearest integer:

If you want to round the number 4.5 up to the nearest integer using `ISO.CEILING`, you would enter the following formula:

   =ISO.CEILING(4.5)

This would return `5`.

Round a number to the nearest multiple of 5:

To round the number 7.2 up to the nearest multiple of 5:

   =ISO.CEILING(7.2, 5)

This would return `10`.

Round a negative number up towards zero:

If you want to round -9.8 up to the nearest integer, towards zero:

   =ISO.CEILING(-9.8)

This would return `-9`.

Key Points

`ISO.CEILING` handles both positive and negative numbers and behaves consistently regardless of the number’s sign, which means it rounds up towards zero.
The function is available in Excel 2013 and later, as well as in Excel for Microsoft 365.
Unlike the `CEILING` function, `ISO.CEILING` doesn’t require you to consider the sign of the number. `CEILING` rounds away from zero for negative numbers, and `CEILING.MATH` offers additional options for rounding direction.

When using `ISO.CEILING`, ensure that your version of Excel supports the function and that you’ve entered the correct values for `number` and `significance` to achieve the desired results.

facebooklinkedin