Reader Level:
Microsoft Office

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.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 6k
  • 0

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: