FLOOR.MATH(number [,significance] [,mode])
Returns the number rounded down to the nearest integer or significant figure (inc. negative).
|number||The 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
|* 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
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top