CEIL

Returns the nearest integer, greater than or equal to the specified value.

Sample Usage

CEIL(Height)

Syntax

CEIL(X)

Parameters:

  • X - a field or expression containing at least one field.

Note

  • CEIL(X) is always greater than or equal to X.

Examples

Formula Input Output
CEIL(Height) 20.34 21
CEIL(Height) -40.3 -40
CEIL(Height) 50 50

Related resources

Was this helpful?
How can we improve it?