Reader Level:

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.


Step 3

Now write the numbers and significance number as follows:


Step 4

Now write the following function:


Step 5

The output will be like this:




JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.
Infragistics jQuery Controls

Trending up