Excel > Functions

CEILING Function

The Excel CEILING function is used to round a number up to a multiple of significance. For example, you could round a number up to 2 decimal places, or to the next multiple of 5.

The syntax for the CEILING function is:

=CEILING(number,significance)

Argument

Purpose

Number

The number you want to round up

Significance

The multiple of sigificance you want to round the number up to.

This must match the sign of the number you are using. For example, you cannot round a negative number to a positive number

Below are examples of the CEILING function being used to round numbers up to various multiples.

Data to use for CEILING function

Function

Result

=CEILING(A1,0.1)

5.4

=CEILING(A2,1)

3

=CEILING(A3,0.1)

4.6

=CEILING(A4,5)

25

Follow us on

Facebook  Twitter  You Tube 

Other Mathematical Functions

Excel 2010 Superhero Course