CEILING

Description

Returns the smallest integer greater than or equal to the specified number.

Syntax

CEILING(num) -> Decimal

Parameters

ParameterData TypeRequiredDescription
numDecimalYesThe value or numeric field to round up.

Examples

CEILING(1.1)
-- Return 2.
CEILING(-1.1)
-- Return -1.