Export (0) Print
Expand All

FLOOR Function

Rounds a number down, toward zero, to the nearest multiple of significance.

FLOOR(<number>, <significance>)

Term

Definition

number

The numeric value you want to round.

significance

The multiple to which you want to round. The argumentsnumber and significance must either both be positive, or both be negative.

A decimal number.

If either argument is nonnumeric, FLOOR returns #VALUE! error value.

If number and significance have different signs, FLOOR returns the #NUM! error value.

Regardless of the sign of the number, a value is rounded down when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.

The following formula takes the values in the [Total Product Cost] column from the table, InternetSales.and rounds down to the nearest multiple of .1.

=FLOOR(InternetSales[Total Product Cost],.5)

The following table shows the expected results for some sample values.

Values

Expected Result

10.8423

10.8

8.0373

8

2.9733

2.9

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft