Skip to main content

​​​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!

 

 

Be the first to reply!