Reader Level:
Article
Microsoft Office

Ceiling.Math Function in Excel 2013

By Megha Goyal on Oct 11, 2012
In this article we will discuss how to use Ceiling.Math function in Excel 2013.

This is a new function introduced in Excel 2013. This function is used to round a number up to the nearest integer or to the nearest multiple of significance. The syntax of this function is as follows: =Ceiling.math(number,[significance]) where significance is optional. The significance indicates the multiple of the number to which we want to round off the number. For example if we will take =Ceiling.math(56.3,3) then it will round the number 56.3 up to the nearest integer that is a multiple of 3 (57) so it will return 57. If we will use =Ceiling.math(45.6,6) then it will return 48.

Let's have a look at the following procedure.

Step 1

Go to Excel 2013.

Step 2

Now select a blank workbook template from the available templates.

Ceiling-math-function-in-excel2013.jpg

Step 3

Now write the numbers and significance number as follows:

Excel2013-with-ceiling-math-function.jpg

Step 4

Now write the following function:

use-of-ceiling-math-function-in-excel2013.jpg

Step 5

The output will be like this:

excel2013-with-ceiling-math-function1.jpg