ISO.CEILING
Description
Rounds a number up to the nearest integer, based on the multiple of significance that
you specify. The function doesn't consider the number's sign. The function rounds
positive numbers up, and also rounds negative numbers up (toward zero, becoming less
negative).
Syntax
ISO.CEILING(
value
, [
multiple
])
- value: The number to round up.
- multiple: The multiple of significance to round the number up to. If you omit the argument, the function uses the value 1, which causes the function to round the number up to the next larger integer.
Example
Formula | Result |
|---|---|
=ISO.CEILING(12.34) | 13 |
=ISO.CEILING(12.34,1) | 13 |
=ISO.CEILING(-12.34,1) | -12 |
=ISO.CEILING(12.34,0.1) | 12.4 |
Notes
- This function does the same action as ISOCEILING() and CEILING.PRECISE().