Excel: Ceiling Function
In Excel, the Ceiling function returns a number rounded up based on a multiple of significance.
The syntax for the Ceiling function is:
Ceiling( number, significance )
number is the number that you wish to round up.
significance is the multiple of significance that you wish to round a number to.
Note:
If the sign of the number and the significance parameters are different, the Ceiling function will return the #NUM! error.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:

Based on the Excel spreadsheet above:
=Ceiling(A1, 1) would return 211 =Ceiling(A1, 0.05) would return 210.7 =Ceiling(210.63, 0.05) would return 210.65 =Ceiling(A2, 2) would return 4 =Ceiling(A3, 2) would return #NUM! =Ceiling(-4.5, -1) would return -5
