# CEILING.MATH

Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.

### Sample Usage

CEILING.MATH(-5.25, 10, 1)
CEILING.MATH(A4, A5)

### Syntax

CEILING.MATH(number, [significance], [mode])

• number - The number to be rounded.
• significance - [OPTIONAL] The number to whose multiples the value will be rounded.
• mode - [OPTIONAL] Specifies the rounding direction in case of negative numbers.
•  If set to 0 or left blank, the number is rounded up towards zero. Otherwise, it's rounded down away from zero.

### Examples

CEILING.MATH(-15.5100) rounds the number towards zero, and returns the number -10.
CEILING.MATH(-15.5102) rounds the number away from zero, and returns the number -20.

### Notes

• By default, significance is +1 for positive numbers and -1 for negative numbers. By specifying the significance and mode arguments, you can change the direction of the rounding.
• By default, positive numbers with decimal places are rounded up to the nearest integer.
• By default, negative numbers with decimal places are rounded up towards zero to the nearest integer. For example, -2.6 is rounded up to -2.