CEILING.PRECISE
Description
Rounds a number up to a multiple of 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
CEILING.PRECISE(
value
, [
significance
])
- value: The number to round up.
- significance: 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 |
|---|---|
=CEILING.PRECISE(12.34) | 13 |
=CEILING.PRECISE(12.34,1) | 13 |
=CEILING.PRECISE(-12.34,1) | -12 |
=CEILING.PRECISE(12.34,0.1) | 12.4 |
Notes
- This function does the same action as ISO.CEILING() and ISOCEILING().