Excel 2010: CEILING Function

Excel 2010 provides a list of mathematical functions that enable you to evaluate complex logic instantly. From the list of functions provided, finding out Ceiling value would be useful, especially when you need to find it out for specified “multiple”. Excel 2010 CEILING function immediately evaluates the ceiling value based on specified multiple. In this post, we will explain how you can find out the smallest value of the next integer according to specified multiple.

To begin, launch Excel 2010 spreadsheet on which you want to apply the ceiling function. For instance, we have included a spreadsheet containing fields; S.No, Values, and Ceiling.

celing

Now, we want to find out the ceiling of the data present in the Value field. For this we will be using ceiling function, The syntax of the function is;

=CEILING(number. significance)

The first argument is a number which refers to number for which you want to show ceiling, and significance refers to any number of which nearest multiple is needed.

We will be writing this function as;

=CEILING(A1,2)

The first argument is A1 which refers to the location of the cell, however you can also type in the value, directly. The second argument is 2 which refers to the nearest multiple of 2.


As shown below, it shows 16 for the data 15 in the Value field. It searched for the nearest significant value which is multiple of 2, the options were 14 and 16 nearest to value 15, as we are finding out ceiling that’s why it shows 16 as a result.

ceiling2

Now for applying it over the field just drag down the plus sign at the end of the cell (containing the function) towards the end of the column.

Capture

Now if you want to show the nearest whole number ceiling value, then just change the significance in the function to 1. It would come useful in situations where you’re dealing with decimal values.

celing decimal

For finding out ceiling of the value exclusively you need to put in first argument directly.

DIRECT

You can also check out previously reviewed Excel functions; RANK, TIME, ADDRESS ,FACT (factorial), MAX,MIN, MAXA, MINA and EXACT, Logical Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, & LEN.

Advertisement