FLOOR.MATH(number [,significance] [,mode]) |
Returns the number rounded down to the nearest integer or significant figure (including 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 an exact multiple of "significance", there will be no rounding. * 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. * You can use the TRUNC function to return the number with any decimal places removed. * You can use the INT function to return a number rounded down to the nearest integer. * For the Microsoft documentation refer to support.office.com |
|
Rounding down to the nearest 20 minutes. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top