Rounds up, i.e. returns the nearest long integer value that is larger than or equal to the specified input value.
Syntax
CEIL(Value)
Input
Value | is a value |
Domain type: | any Value domain |
Output
CEIL returns: | a long integer value |
Domain: | system domain Value |
Note:
When the input value is undefined, the output will also be undefined.
Tip:
When the definition symbol = is used, a dependent output map or dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output map/column has been calculated.
Usable in
MapCalc, TabCalc, Simple calculators
Examples
Pocket line calculator examples:
? CEIL(0.5) |
returns 1 |
? CEIL(-3.5) | returns 3 |
? CEIL(ABS(-3.5)) | returns 4 |
MapCalc example:
OutMap = CEIL(InMap)
InMap |
OutMap |
||||||||||||||||||
|
|
TabCalc example:
OutCol = CEIL(InCol)
InCol |
OutCol |
-1.6 |
-1 |
-1.5 |
-1 |
-1.4 |
-1 |
? |
? |
0 |
0 |
1 |
1 |
1.4 |
2 |
1.5 |
2 |
1.6 |
2 |
See also: