It returns a number rounded up, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the CEILING function.
The syntax of the function is the following:
CEILING.MATH(number, [significance], [mode])
number: The number we need to round up.
[significance]: Optional. The multiple of significance we wish to round up to.
[mode]: Optional. It controls if the number will be rounded towards or away from zero.
The default value of significance is +1 for positive numbers and -1 for negative numbers.
The mode argument does not affect positive numbers