CEILING function

Prev Next

​​​Description

Rounds up a Number to the nearest Integer value.

Syntax

CEILING(Number to Round Up)

Arguments

Argument

Type

Dimensions

Description

Number to Round Up

(required)

Number

Any Dimensions

Decimal number to round up.

Returns

Type

Dimensions

Number

Dimensions of Number to Round Up

Examples

Formula

Result

Description

CEILING(2.36)

3

The nearest integer up of 2.36 is 3.

CEILING(-2.36)

-2

The nearest integer up of -2.36 is -2.

See also

Excel: CEILING.MATH

Related articles: FLOOR

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!