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**

CEILINGMATH(-5.25, 10, 1)

CEILINGMATH(A4, A5)

**Syntax**

CEILINGMATH(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**

CEILINGMATH(-15.5, 10, 0) rounds the number towards zero, and returns the number -10.

CEILINGMATH(-15.5, 10, 2) 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.