CEILING

Rounds a number up to the nearest multiple of a given significance factor.

Parameter List

Syntax
CEILING(number
[factor]
)
number

The value to be rounded up.

[optional] factor

The multiple to which the number is to be rounded up.

Examples

CEILING(1.5, 1) returns returns 2.