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.|
|* 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.office.com
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top