# FLOOR function

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

## Syntax

FLOOR(number,significance)

Number     is the numeric value you want to round.

Significance     is the multiple to which you want to round.

## Remarks

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

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

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

## Examples

Formula

Description (Result)

=FLOOR(2.5, 1)

Rounds 2.5 down to nearest multiple of 1 (2)

=FLOOR(-2.5, -2)

Rounds -2.5 down to nearest multiple of -2 (-2)

=FLOOR(-2.5, 2)

Returns an error, because -2.5 and 2 have different signs (#NUM!)

=FLOOR(1.5, 0.1)

Rounds 1.5 down to the nearest multiple of 0.1 (1.5)

=FLOOR(0.234, 0.01)

Rounds 0.234 down to the nearest multiple of 0.01 (0.23)

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

×