Syntax
CEILING.MATH(number, [significance], [mode])
| Parameter | Description |
|---|---|
| number | Parameter of the CEILING.MATH function. |
| [significance] | (Optional.) Parameter of the CEILING.MATH function. |
| [mode] | (Optional.) Parameter of the CEILING.MATH function. |
Examples
Round up to integer
Formula
=CEILING.MATH(4.2)
Returns 5. Without a significance, it rounds up to the next whole number.
Round to nearest 10
Formula
=CEILING.MATH(83, 10)
Returns 90. Rounds 83 up to the next multiple of 10.
Negative with mode
Formula
=CEILING.MATH(-7.5, 2, 1)
Returns -8. With mode=1, negative numbers round away from zero. Without mode (or mode=0), -7.5 rounds to -6 (toward zero).
Common Errors
#VALUE!
All arguments must be numeric. Text values cause #VALUE!.
#DIV/0!
Significance of 0 returns #DIV/0!.
Tips
Safe replacement for CEILING
CEILING.MATH never errors on negative numbers with positive significance, unlike CEILING. Use it as your default.
Significance defaults to 1
=CEILING.MATH(x) is the same as =CEILING.MATH(x,1). It rounds up to the next integer.
Mode controls negative direction
Mode=0 (default): negatives round toward zero (less negative). Mode=1: negatives round away from zero (more negative). Positive numbers are unaffected by mode.
Try CEILING.MATH in Viztab
Import your data and use CEILING.MATH with 370+ other formulas. No signup required.
Open Viztab