CEIL: Returning the Smallest Integer Greater Than or Equal to a Value

How to:

CEIL returns the smallest integer value not less than the argument. CEILING is a synonym for CEIL.

Syntax: How to Return the Smallest Integer Greater Than or Equal to a Value

CEIL(n)

where:

n

Numeric or Alphanumeric

Is the value less than or equal to the returned integer. For exact-value numeric arguments, the return value has an exact-value numeric type. For alphanumeric or floating-point arguments, the return value has a floating-point type.

Example: Returning an Integer Greater Than or Equal to a Value

CEIL returns an integer greater than or equal to the argument.

CEIL(N)

For N=1.23, the result is 2.

For N=-1.23, the result is -1.

WebFOCUS

Feedback