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

How to:

CEILING returns the smallest integer value that is greater than or equal to a number.

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

CEILING(number)

where:

number

Numeric

Is the number whose ceiling will be returned. The output data type is the same as the input data type.

CEILING returns the smallest integer larger than the value in GROSS_PROFIT_US:

CEILING(GROSS_PROFIT_US)

For 225.98, the output is 226.00.

For -30.01, the output is -30.00.

	WebFOCUS