Excel FLOOR.PRECISE Function

Basic Description

The Excel Floor.Precise function rounds a supplied number down (regardless of the number's sign), to the nearest multiple of a given number.

The syntax of the function is:

FLOOR.PRECISE( number, [significance] )

Where the arguments are listed in the table below:

number - The initial number that is to be rounded down
[significance] -

An optional argument that specifies the multiple of significance to round the supplied number down to.

If omitted, the significance argument takes on the default value 1

Note that the arithmetic sign of the [significance] argument is ignored. The supplied number is rounded down for both positive and negative [significance] values.


Floor.Precise Function Examples

The following spreadsheet shows the Excel Floor.Precise function used with several different significance values, on the positive and negative numbers 26.75 and -26.75.

 Formulas:
  A B
1 number floor.precise
2 26.75 =FLOOR.PRECISE( A2, 0.1 )
3 26.75 =FLOOR.PRECISE( A3, 0.5 )
4 26.75 =FLOOR.PRECISE( A4, 1 )
5 26.75 =FLOOR.PRECISE( A5 )
6 26.75 =FLOOR.PRECISE( A6, 10 )
7 26.75 =FLOOR.PRECISE( A7, 0 )
8 -26.75 =FLOOR.PRECISE( A8, -0.1 )
9 -26.75 =FLOOR.PRECISE( A9, 0.1 )
10 -26.75 =FLOOR.PRECISE( A10, 5 )
 Results:
  A B
1 number floor.precise
2 26.75 26.7
3 26.75 26.5
4 26.75 26
5 26.75 26
6 26.75 20
7 -26.75 0
8 -26.75 -26.8
9 -26.75 -26.8
10 -26.75 -30

The above examples show how:


Further information and examples of the Excel Floor.Precise function can be found on the Microsoft Office website.


Floor.Precise Function Error

If you get an error from the Excel Floor.Precise function, this is likely to be the following :

Common Error
#VALUE! - Occurs if one or both of the supplied arguments are non-numeric.