CEILING Function in Excel

So, for example, if we have the number 10 and significance as 3 then 12 will be the result.

Syntax

Compulsory Parameter:

  • number: It is the value that you want to round off.significance: It is the multiple that we want to round up.

How to Use the CEILING Function in Excel?

Example #1

Let us take a set of positive integers as number arguments and positive numbers as significance, then apply the CEILING Excel function below. It will show the output in the result.

Example #2

In this example, we take a set of negative integers as number arguments and positive numbers as significance, then apply the CEILING Excel formula as shown in the table below. The output will be shown in the result as follows:

Example #3 

In this example, we take a set of negative integers as number arguments and negative numbers as significance, then apply the CEILING Excel formula to it.

Example #4

We can use the excel CEILING formula to highlight the rows in the group of given data, as shown in the below table. We will use the CEILING in Excel with ROW and ISEVEN functions.

Suppose we are given the data below:

And, If we wish to highlight the rows in the given groups of 3, we can use the Excel formula: =ISEVEN(CEILING(ROW()-19,3)/3) in conditional formattingConditional FormattingConditional formatting is a technique in Excel that allows us to format cells in a worksheet based on certain conditions. It can be found in the styles section of the Home tab.read more, and the output will be as follows:

Things to Remember

  • #NUM! error: It may occur in MS Excel 2007 or earlier versions. For example, if we provide the significance argument with a different arithmetic sign from the given number argument, get #NUM! Error.It occurs if you are using MS Excel 2010/2013, then CEILING functions through #NUM! Error if the given number is positive and the supplied significance is negative.#DIV/0! Error occurs when the significance parameter is zero.#VALUE! Error occurs when any of the parameters is non-numeric.Excel CEILING function is the same as MROUND, but it always rounds up away from zero.

This article has been a guide to the CEILING function in Excel. Here we discuss the CEILING formula in Excel and how to use the CEILING function and Excel example, and downloadable Excel templates. You may also look at these useful functions in Excel: –

  • It may occur in MS Excel 2007 or earlier versions. For example, if we provide the significance argument with a different arithmetic sign from the given number argument, get #NUM! Error.It occurs if you are using MS Excel 2010/2013, then CEILING functions through #NUM! Error if the given number is positive and the supplied significance is negative.

  • SIGN in ExcelCLEAN Excel FunctionDAY Function in ExcelTangent in ExcelMaximum Number of Rows in Excel