Reader Level:

FLOOR.MATH Function in Excel 2013

By Megha Goyal on Oct 05, 2012
In this article we will discuss how to use the Floor.math function in Excel 2013.

This is the new function introduced in Excel 2013. This function is used to round a number down to the nearest integer or to the nearest multiple of significance. The syntax of this function is as follows: =floor.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 =floor.math(23.3,5) then it will round the number 23.3 down to the nearest integer that is multiple of 5 (20) so it will return 20. If we will use =floor.math(65.2,5) then it will return a multiple of 5 (65).

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now open a Blank workbook template from the available templates.


Step 3

Now take the following numbers and their significance values:


Step 4

Now write the following function:


Step 5

The output will be like this: