CEILING.MATH
Description
Rounds a number up to the nearest integer, based on the significance and mode that
you specify.
Syntax
CEILING.MATH(
value
, [
significance
], [
mode
])
- 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 for positive numbers and -1 for negative numbers.
- mode: Applicable only to negative numbers. If you specify -1, the function rounds negative numbers down, becoming more negative. If you omit the argument or specify any other number, the function rounds negative numbers up, toward zero.
Example
Formula | Result |
|---|---|
=CEILING.MATH(12.34) | 13 |
=CEILING.MATH(12.34,0.1) | 12.4 |
=CEILING.MATH(12.34,0.5) | 12.5 |
=CEILING.MATH(12.34,10) | 20 |
=CEILING.MATH(-12.34) | -12 |
=CEILING.MATH(-12.34,-1) | -12 |
=CEILING.MATH(-12.34,-0.1) | -12.3 |