SpreadJS Documentation / Formula Reference / Formula Functions / CEILING.MATH
In This Topic
CEILING.MATH
In This Topic

This function rounds up the given numeral to the nearest multiple of the specified value.

#### Syntax

CEILING.MATH(value, signif, mode)

#### Arguments

This function has the following arguments:

Argument Description
value Refer to the number you want to round off.
signif [Optional] Refers to the number representing the rounding factor.
mode [Optional] Represents the direction (towards or away from 0) to round negative value.

By default, significance is +1 for positive numerals and -1 for negative numerals.

#### Remarks

Positive numbers with decimal parts are rounded up to the nearest integer.

Negative numbers with decimal parts are rounded up (toward 0) to the nearest integer.

#### Data Types

Accepts numeric data for all arguments. Returns numeric data.

#### Examples

CEILING.MATH(14.1,5) gives the result 15

CEILING.MATH(26.2) gives the result 27.

CEILING.MATH(-14.1,7) gives the result -14.