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: