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.

CEILING

Purpose:

Syntax:

Returns:

Example:

Example:

Example:

Remarks:

See Also: