CEILING

Excel Functions

Round a number up to nearest multiple

Syntax

EXCEL

=CEILING(number, significance)

Arguments

Parameter	Description
`number`	The number that should be rounded.
`significance`	The multiple to use when rounding.

Return Value

A rounded number.

Details

The Excel CEILING function rounds a number up to a given multiple. The multiple to use for rounding is provided as the significance argument. If the number is already an exact multiple, no rounding occurs and the original number is returned. The CEILING function takes two arguments, number, and significance. Number is the numeric value to round up. The significance argument is the multiple to which number should be rounded. In most cases, significance is provided as a numeric value, but CEILING can also understand time entered as text like "0:15". See the example below. CEILING works like the MROUND function, which also rounds to a given multiple. However, unlike MROUND, which rounds to the nearest multiple, the CEILING function rounds up to the next multiple. Note: the CEILING function is

Examples

The formulas below show how CEILING rounds up values to a given multiple:

EXCEL

=CEILING(10,3) // returns 12
=CEILING(36,7) // returns 42
=CEILING(309,25) // returns 325
=CEILING(610,100) // returns 700
=CEILING(-5.4,1) // returns -5

Examples

To round a number in A1 up to the nearest multiple of 5, you can use a formula like this:

EXCEL

=CEILING(A1,5)

Round pricing up to end with .99

CEILING can be useful to set pricing after currency conversion or discounts are applied. For example, the formula below will round a value in A1 up to

EXCEL

=CEILING(A1,1) - 0.01

Round time up to nearest 15 minutes

CEILING understands time formats and can be used to round time up to a given multiple. For example, to round a time in A1 up to the nearest 15 minutes

EXCEL

=CEILING(A1,"0:15") // round up to nearest 15 min

CEILING

Syntax

Arguments

Return Value

Details

Examples

See Also