Ceiling Excel Formula

Author Zaheer    Category Formulas     Tags ,

In science and mathematics, ceiling functions map the real number two biggest previous or smaller following integer. More specifically, floor is the prime integer and not the integer as compared to x and ceiling x is smaller integer. The concept of square bracket notation was introduced by Carl Friedrich Gauss which was as [x] for floor function in his 3rd proof of the quadratic reciprocity in the year 1808. He remained the average mathematics till Kenneth E. Iverson launched the names ceiling and the matching notations x plus x in his book Programming Language in 1962. Both of these notations are currently used in math and were followed by Iverson.

Ceiling function is typically refers to by ceil (x) or ceiling(x) in non APL computer languages which have notations for the function. The Programming Language, follow on to the APL which is designed to employ ordinary keyboard signs, uses >For ceiling and <For floor, in the field of mathematics, there is another notation with double brackets or reversed boldface or simply making use of ordinary normal reversed brackets such as ] x [.

Ceiling Function Description:

Ceiling function is use to round the number upward the nearest multiple of the specified value. For instance, the function can also be use to round up cost to nearest dime $0.10 to prevent having deal with the smaller change such pennies $0.01 and nickel $0.05.

Ceiling Function Syntax:

= CEILING (number, significance)


NUMBER – is the value to be rounded

SIGNIFICANCE – is the function round the number specified above to the nearest multiple

Example: Using CEILING Function in Excel

For assistance with the example, check out the following:

  • Enter the following data in the cells D1 up to D3: 34.57, 23.82, and 31.16
  • Then, click on the cell E1 in spreadsheet. It is where function would be situated
  • Click in the formula tab of ribbon menu
  • Next, opt for Math and Trig from the ribbon menu to open the function and drop down lists
  • Click Ceiling in the lists to bring you the function dialog box
  • And then, in the dialog box click the Number Line
  • Click on the Cell D1 in spreadsheet
  • In dialog box, you have to click on Significance line
  • Subsequently, type in 0.10 which is the number in D1 that will be rounded up in the nearest multiple of 0.10
  • Click OK
  • Answer 34. 50 must appear in the cell E1 since the 34. 60 is the closest multiple of 0.10. (0.10 * 6) higher than the 34.57
  • And then, drag the fill handle at the bottom right corner of the cell E1 down to the cell D2 and D3 to duplicate the function to the cells
  • The cell D2 and D3 must have the answer 23. 90 and then 31.30 correspondingly
  • If you click on the Cell E1 the complete functions =CEILING (d1, 0.1) will appear in the formula bar just above the worksheet.

Other Examples:

Examples: Evaluate the ceiling function (x) for different values of x.

  • ceiling(1.5) = 2
  • ceiling(0) = 0
  • ceiling(2) = 2
  • ceiling(- 3) = – 3
  • ceiling(- 1.5) = – 1

Post comment