DriveWorks Pro 15: Ceiling [send feedback...]

Ceiling

The Ceiling function will round negative numbers.

Ceiling rounds a number up to the nearest specified significance.

Syntax

CEILING( [Number], [Significance] )

Number is the number to round.

Significance is the number to which this function finds the nearest (higher valued) multiple of.

Examples

Rule

Meaning
CEILING(123.456, 9)Rounds the number 123.456 up to the nearest multiple of 9. The resulting value is 126.
CEILING(-1.234,1)Rounds the number -1.234 up to the nearest multiple of 1. The resulting value is -1.

Table of Contents