A to Z of Excel Functions: the FLOOR.MATH Function
5 August 2019
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the FLOOR.MATH function.
Not to be confused with a floor mat... This function actually rounds a number down to the nearest integer or to the nearest multiple of significance (see below).
The FLOOR.MATH function employs the following syntax to operate:
FLOOR.MATH(number, [significance], [mode])
The FLOOR.MATH function has the following arguments:
- number: this is required. This number is what is to be rounded (down for positive numbers)
- significance: this is optional. This represents the multiple to which number is to be rounded
- mode: also optional. For negative numbers, this controls whether number is rounded toward or away from zero.
It should be further noted that:
- by default, positive numbers with decimal portions are rounded down to the nearest integer, e.g. 6.3 is rounded down to 6, using the default significance (1)
- by default, negative numbers with decimal portions are rounded away from 0 to the nearest integer, e.g. -6.7 is rounded to -7
- by using 0 or a negative number as the mode argument, you can change the direction of the rounding for negative numbers. For example, rounding the number -6.3 with a significance of 1 and a mode of -1 rounds toward zero (0), to -6
- the significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer. For example, for a significance of 3, the number is rounded down to the last integer that is a multiple of 3
- if number divided by a significance of 2 or greater results in a remainder, the result is rounded down.
Please see my example below:
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every other business day.
A full page of the function articles can be found here.