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 |
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 |
|
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top