CEILING

Purpose:

Finds the smallest integer greater than or equal to the input value.

Syntax:

CEILING(val)

val

-

A scalar or series or table.

Returns:

A scalar, series, or table.

Example:

ceiling(2.4)

 

returns 3, whereas round(2.4) returns 2.

Example:

ceiling(-2.4 + 7.2i)

 

returns -2.0 + 8.0i.

Example:

ceiling(W2)

 

creates a new series by applying CEILING to each series element of Window 2. The integer value returned by CEILING is converted to a floating point value.

Remarks:

CEILING can be abbreviated CEIL. Use ROUND to round the value up.

See Also:

FIX

FLOOR

INT

ROUND