CEILING Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> CEILING Function in Excel



In this tutorial, you will deepen your understanding of all things about CEILING formula in excel, starting from why CEILING function in excel is needed to how to use it. CEILING formula in excel is useful to round up a number based on the multiplication factor that we desire for the result.


Why do We Need to Learn CEILING Formula in Excel?


In doing numeric data processing in a spreadsheet, sometimes we need to do a multiplication factor rounding process on a calculation result or a digit that we want to use in calculation. In doing the round process, sometimes our needs require us to round it up to the nearest larger multiplication factor that we need.

As case example in work or business for this need is when we want to analyze the budget needed to do a project in a company or the product quantity that is needed to be prepared and produced to anticipate the demand of the product in an upcoming period.

While doing the analysis process to determine the two of them, we can probably use the average calculation process by utilizing historical data of the financial needs for this kind of project or the amount of demand for the product that we want to analyze the number of production results needed on. This process will result in prediction numbers and for both cases, it is possibly better if we round the results based on a multiplication factor of a number so they can be used for more real benchmarks for the budget preparation or production batch calculation for the company’s factory.

In doing the rounding to the multiplication factor of a number, maybe it is better to round them up because if the budget or production amount is less then the actual needs for them, then it can badly impact the company in terms of the project that cannot be done well or there will be unsatisfied demand for our product.

To help the process in rounding up to a number multiplication factor to be more automatic, you can use CEILING function in excel. CEILING formula in excel can round up the number input you give to the multiplication factor that you want. It is very useful to be understood if you often deal with the numeric data calculation in a spreadsheet.


What is CEILING Function in Excel?


CEILING function in excel is a function with the usage objective to round a numeric data up to the larger multiplication factor of a number that we want. In this spreadsheet software, there are other formulas to do the rounding process with their distinct function such as MROUND and FLOOR. The complete explanation for all the formulas can be learned in another part of Compute Expert tutorial!

A bit explanation on the inputs in this formula is as follows:


=CEILING(number, significance)


Note:
  • number = the digit that you want to round up based on your multiplication factor demand
  • significance = the number multiplication factor for the benchmark of the rounding process



How to Use CEILING Formula in Excel?


The following will explain how to write CEILING function in excel. The writing of CEILING formula in excel needs the inputs of the number that you want to round up and the multiplication factor needs for the result later.


Using CEILING Function in Excel


  1. Type equal sign ( = ) in the cell where you want to put the result in

    CEILING Function in Excel - Screenshot of Step 1

  2. Type CEILING (can be with large and small letters) and open bracket sign after =

    CEILING Function in Excel - Screenshot of Step 2

  3. Type number / cell coordinate where the number which you want to process is after open bracket sign followed by a comma sign ( , )

    CEILING Function in Excel - Screenshot of Step 3

  4. Type the multiplication factor demanded / cell coordinate where the multiplication factor demanded is

    CEILING Function in Excel - Screenshot of Step 4

  5. Type close bracket sign

    CEILING Function in Excel - Screenshot of Step 5

  6. Type Enter
  7. The process is done!

    CEILING Function in Excel - Screenshot of Step 7



Exercise


After you learn how to use the CEILING formula in excel, you can practice and sharpen your understanding by doing the exercise below!

Download the file from the following link and answer the questions. Please download the answer key file to compare your answers with if you have done the exercise and sure about the result!

Link to download the exercise file:
Download here

Questions

  1. What is the production quantity for the benchmark of the company’s factory if the standard batch is 10?
  2. What is the production quantity for the benchmark of the company’s factory if the standard batch is 50?
  3. What is the production quantity for the benchmark of the company’s factory if the standard batch is 1000?

Link to download the answer file:
Download here


Additional Notes

  • You can also input minus digit in the multiplication factor part of CEILING formula in excel. But, if the input for that part is minus, then the input of number that you want to round also has to be minus. CEILING function in excel will make the number minus bigger (not, instead, make it more positive)

    CEILING Function in Excel - Screenshot of Additional Notes 1-1

    CEILING Function in Excel - Screenshot of Additional Notes 1-2

  • If your need is rounding up a decimal number according to your decimal amount needs, then you can use ROUNDUP formula instead




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert