ceil()

Description:

Truncate data at the specified position, and carry the remaining part if any.

Syntax:

ceil(numberExp, {nExp})

Note:

The function truncates data numberExp at the specified position nExp, and carry the remaining part (if any).

Parameters:

numberExp

Data to be truncated

nExp

An integer number specifying the truncate position; taken as 0 when it is omitted

>0: Move the decimal point to the right for nExp places,

<0: Move the decimal point to the left for nExp places,

=0: Indicate the current decimal place.

Return value:

Numeric

Example:

ceil(3450001.004,0)

3450002.0

ceil(3450001.004,-1)

3450010.0

ceil(3450001.004,-2)

3450100.0

ceil(3450001.004,1)

3450001.1

ceil(3450001.004,2)

3450001.01

Related functions:

floor()

round()