ISO.CEILING function
The ISO.CEILING function in Excel is used to round a number up to the nearest multiple of a specified significance value, following the ISO standard for rounding.
Syntax
=ISO.CEILING(number, significance)
Parameters
number: The number you want to round up.significance: The multiple to which you want to round the number up. This value must be a positive number.
Return Value
The function returns the number rounded up to the nearest multiple of the specified significance. The result will always be greater than or equal to the original number.
Key Points
- ISO.CEILING rounds up the number to the nearest multiple of significance, similar to the CEILING function but adhering to the ISO standard.
- It rounds up even if the value is already a multiple of the significance, unlike CEILING which might leave the value unchanged if it is already a multiple.
Examples
Example 1: Round 3.7 to the nearest multiple of 1
=ISO.CEILING(3.7, 1)
Result: 4
Explanation: The next multiple of 1 greater than or equal to 3.7 is 4.
Example 2: Round 3.7 to the nearest multiple of 0.5
=ISO.CEILING(3.7, 0.5)
Result: 4
Explanation: The next multiple of 0.5 greater than or equal to 3.7 is 4.
Example 3: Round 8.1 to the nearest multiple of 2
=ISO.CEILING(8.1, 2)
Result: 10
Explanation: The next multiple of 2 greater than or equal to 8.1 is 10.
Example 4: Round 3.5 to the nearest multiple of 1
=ISO.CEILING(3.5, 1)
Result: 4
Explanation: The next multiple of 1 greater than or equal to 3.5 is 4.
Difference Between ISO.CEILING and CEILING
- ISO.CEILING follows the ISO standard, which rounds up to the next multiple of the significance, even if the number is already a multiple.
- CEILING, while also rounding up to a specified multiple, may not round if the number is already a multiple of the significance (depending on the value of the number and significance).
Use Case
The ISO.CEILING function is particularly useful when you need to ensure that numbers are always rounded up to a specific multiple for standardized reporting, especially in financial calculations or when adhering to specific rounding rules for compliance.