FLOOR.MATH(number [,significance] [,mode])

Returns the number rounded down to the nearest integer or significant figure (inc. negative).

numberThe number to be rounded down.
significance(Optional) The multiple you want the number rounded to.
mode(Optional) Whether to round negative numbers up or down:
False = Negative numbers are rounded up towards zero (default)
True = Negative numbers are rounded down away from zero

Remarks

* Added in Excel 2013.
* This function replaces the FLOOR.PRECISE function.
* This function replaces the FLOOR function.
* If "significance" is left blank, then 1 is used.
* If "mode" is left blank, then False is used.
* The "mode" argument only affects negative numbers.
* The "mode" argument can also take numerical values. 0 is equivalent to False. Any other number is equivalent to True.
* If "number" is divided by a significance of 2 or greater, results in a remainder, the result is rounded down.
* Positive decimal numbers are rounded down to the nearest integer.
* Negative decimal numbers are rounded down to the nearest integer.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the MROUND function to round to a desired multiple.
* You can use the ROUND function to round to a specified number of digits.
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top