FLOOR.MATH Function
Description
The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of significance.
Syntax
FLOOR.MATH (number, significance, mode)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The number to be rounded down. | Required |
Significance | The multiple to which you want to round. | Optional |
Mode | The direction (toward or away from 0) to round negative numbers. | Optional |
Notes
By default, positive numbers with decimal portions are rounded down to the nearest integer.
By default, negative numbers with decimal portions are rounded away from 0 to the nearest integer.
By using 0 or a negative number as the Mode argument, you can change the direction of the rounding for negative numbers.
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.
If Number is divided by a Significance of 2 or greater results in a remainder, the result is rounded down.
If any of the specified arguments is non-numeric, FLOOR.MATH returns #VALUE! Error.
Applicability
Excel 2013, Excel 2016