CEIL(), FLOOR()

The CEIL() function returns the smallest integer not less than the argument value. The FLOOR() function returns the largest integer not greater than the argument value.

Format

CEIL(value)

FLOOR(value)

where

If value is a numeric array, a similarly structured array of result values is returned.

Examples

See also:

ROUNDDOWN(), ROUNDUP()