FLOOR |
FLOOR(number, significance) |
Returns the number rounded down to the nearest integer or significant figure. |
number | The number to be rounded down. |
significance | The multiple you want the number rounded to. |
REMARKS |
* FLOOR.MATH was added in Excel 2013 to replace this function. * If any of the arguments are not numeric, then #VALUE! is returned. * If "number" or "significance" have different signs, then #NUM! is returned (last example ?) * Regardless of the sign of number, a value is rounded down when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top