CEILING

Syntax:

CEILING ( x , significance )

Description: Computes a value that is x rounded-up, away from zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded up when adjusted away from zero.

Arguments:

Name

Type

Description

x

number

The value to be rounded

significance

number

The multiple to which x is to be rounded.

Return Type and Value: number – The rounded-up value of x.

However, if x and significance have different signs, #NUM! is returned.

example: