FLOOR.PRECISE(number [,significance])

Returns the number rounded down to the nearest integer or significant figure.

numberThe number to be rounded down.
significance(Optional) The multiple you want the number rounded to.

* 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

1=FLOOR.PRECISE(-5.2) = -6
2=FLOOR.PRECISE(5.2) = 5
3=FLOOR.PRECISE(5.2, -1) = 5
4=FLOOR.PRECISE(5.2, 2) = 4
5=FLOOR.PRECISE(-5.2, -2) = -6

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top