FLOOR.PRECISE |
FLOOR.PRECISE(number [,significance]) |
Returns the number rounded down to the nearest integer or significant figure. |
number | The number to be rounded down. |
significance | (Optional) The multiple you want the number rounded to. |
REMARKS |
* This function was replaced in Excel 2013 with the FLOOR.MATH function. * This function was added in Excel 2010 to replace the FLOOR function. * This function is only available for backwards compatibility and should never be used. * This function does not appear in the Function Wizard or the Cell AutoComplete. * There was also a CEILING.PRECISE that rounded the number up. * If "significance" is left blank, then 1 is used. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top