CEILING

Rounds numbers up to the nearest integer or specified multiple to ensure values meet required thresholds or standardized increments in your calculations.

The CEILING function rounds a number up to the nearest integer or to the nearest specified multiple (significance). If the number is already an exact multiple of the given significance, it remains unchanged. This function is commonly used in financial calculations, pricing adjustments, quantity estimations, and scenarios where values must always be rounded upward to meet minimum thresholds or standardized increments.

Syntax

CEILING(value, significance)

Arguments

value - Number or cell reference (Required).

significance - Multiple to which the number should be rounded. If missing, the number is rounded to the nearest integer greater than the number (optional).

Example

CEILING(COLUMN)

In the example below, the Rounded_Off Values measure is created using the CEILING function, which returns the nearest integer of the values in the Planned Units measure.

Applying CEILING function

Excel equivalent

CEILING