Home Search

DriveWorks Pro 22
Ceiling

Send Feedback

Ceiling

Ceiling rounds a number up to the nearest specified significance.

The Ceiling function will round negative numbers.

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.