MS Excel: CEILING Function (WS)
In Microsoft Excel, the CEILING function returns a number rounded up based on a multiple of significance.
Syntax
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 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the CEILING function in a worksheet:
Based on the Excel spreadsheet above, the CEILING function would return the following:
| =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(-4.5, -1) | would return -5 |