This Excel tutorial explains how to use the Excel CEILING function with syntax and examples.
Description
The Microsoft Excel CEILING function returns a number rounded up based on a multiple of significance.
The CEILING function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CEILING function can be entered as part of a formula in a cell of a worksheet.
Syntax
If Formulas Excel
Jul 14, 2021 The FORMULATEXT function can be used in troubleshooting and auditing. For example: Show a cell's formula. Calculate the length of a formula. Show the formula in a specific cell. Show the formula, or message if cell does not contain a formula. Watch this video to see how FORMULATEXT works, and there are written instructions below the video. When my spreadsheet was opened by a colleague if had xlfn.Single(sSourceFile) This was a formula referencing a Named Range called sSourceFile. This was not a function that is not supported by my version of Excel; it happened to a simple reference to a Named Range. My colleague has Excel 2016 and I have MS Office 365. Jul 19, 2019 The Excel xlfn. Prefix indicates that your workbook contains a function that is not supported by your version of Excel. This is a common error you many receive, especially is someone sends you a spreadsheet. Most corporate computers do not contain the most recent version of Excel. I accidentally opened a 2007 Excel Workbook (containing an AVERAGEIF formula) in Excel 2003 and now I automatically have the following named range: Name: xlfn.AVERAGEIF Refers to: =#NAME? I believe it is the reason why I keep getting a popup box that says, 'A formula in this worksheet contains one or more invalid references. A possible contributing factor is not just that Office 2011 is a discontinued edition which no longer is supported but that your installation of it isn't even fully updated. Version 14.7.7 released in September, 2017 is the final update & still can be downloaded from this page.
The syntax for the CEILING function in Microsoft Excel is:
Parameters or Arguments
- number
- The number that you wish to round up.
- significance
- 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.
Returns
The CEILING function returns a numeric value.
Applies To
_xlfn Formulas Excel 2011 Online
- Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Example (as Worksheet Function)
Let's look at some Excel CEILING function examples and explore how to use the CEILING function as a worksheet function in Microsoft Excel:
_xlfn Formulas Excel 2011 Free
Based on the Excel spreadsheet above, the following CEILING examples would return: