ISOCEILING
Description
Rounds a number up to the nearest integer, based on the specified significance. 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
ISOCEILING(
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 |
|---|---|
=ISOCEILING(12.34) | 13 |
=ISOCEILING(12.34,1) | 13 |
=ISOCEILING(-12.34,1) | -12 |
=ISOCEILING(12.34,0.1) | 12.4 |
Notes
- This function does the same action as ISO.CEILING() and CEILING.PRECISE.