FLOOR.PRECISE FunctionWayne Becker
The FLOOR.PRECISE function returns a number that is rounded down to the nearest integer or to the nearest multiple of significance.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
||The numeric value to be rounded
||Optional. The multiple to which number is to be rounded
||If [significance] is omitted, its default value is 1
Note: Positive values are rounded towards zero, becoming less positive, and negative values are rounded away from zero, becoming more negative.
||Rounds -3.2 down to the nearest multiple of -1
||Rounds 3.2 down to the nearest multiple of 1
||Rounds -3.2 down to the nearest multiple of 1
||Rounds 3.2 down to the nearest multiple of -1
Common Function Error(s)
||What went wrong
||Occurs if one or both of the supplied arguments are non-numeric