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).

Parameter:

numberExp

Data to be truncated

nExp

An integer 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 type

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()