Excel FLOOR.PRECISE Function

Related Functions:

Excel Rounding Functions

The Excel Floor.Precise function is one of fifteen rounding functions in Excel.

A full list, along with comparison tables, is provided on the Excel Rounding Functions page.

Function Description

The Excel Floor.Precise function rounds a supplied number down to a supplied multiple of significance.

I.e. Positive values are rounded towards zero (becoming less positive) and negative numbers are rounded away from zero (becoming more negative).

The syntax of the Floor.Precise function is:

FLOOR.PRECISE( number, [significance] )

Where the arguments are listed in the table below:

number

The 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 (i.e. round down to the nearest integer).

Note that the arithmetic sign of the [significance] argument is ignored.

Floor.Precise Function Examples

In column B of the following spreadsheet, the Excel Floor.Precise function is used to round down the positive and negative numbers 26.75 and -26.75, to different significance values.

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, 1 )
9	-26.75	=FLOOR.PRECISE( A9, -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	-27
9	-26.75	-27
10	-26.75	-30

The above examples show how:

If the [significance] argument is omitted, it takes on the default value of 1 (see cell B5).
If the [significance] argument is zero, the function returns the value 0 (see cell B7).
The arithmetic sign of the [significance] argument is ignored. The function gives the same result for both positive and negative [significance] values (see cells B8 & B9).
The Floor.Precise function always rounds the supplied number down. I.e. If the supplied number is positive, it is rounded down, towards zero, but if the number is negative it is rounded down, away from zero.

For further details and examples of the Excel Floor.Precise function, see 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 #VALUE! error:

Common Error

#VALUE!

Occurs if one or both of the supplied arguments are non-numeric.

Return to the Excel Math Functions Page
Return to the List of All Built-In Excel Functions