Map and Table Calculation

CEIL( ) function

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

1.4 1.5 1.6
? 0 1
-1.6 -1.5 -1.4
2 2 2
? 0 1
-1 -1 -1

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: