CEIL

The CEIL function returns the ceiling value or next whole number up from the resulting value if the value has a fractional part.

CEIL Syntax

Use the following syntax when incorporating the CEIL function in queries:

CEIL(expression)

Where expression evaluates to a numeric value. If an input value is a whole number, CEIL returns the input value.