Support
Hello,
Select a different account.
You have multiple accounts

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)

### Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.