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: