Related Functions:

The FLOOR function rounds a supplied number down, toward zero, to the nearest multiple of significance.

Syntax

=FLOOR(number,significance)

Arguments

Argument Description
number The numeric value you want to round
significance The multiple that the supplied number is to be rounded to

Note: In Excel 2003 & 2007, the significance argument must have the same arithmetic sign, positive or negative, as the number argument. However, in later versions of Excel, the FLOOR function has been improved, so that it can now handle a negative number argument and a positive significance argument. In this case, the FLOOR function reverses the direction of the rounding, i.e. rounds the supplied number away from zero.

Examples

  A B C
1 Formula Result Notes
2 =FLOOR(3.7,2) 2 Rounds 3.7 down to nearest multiple of 2
3 =FLOOR(-2.5,-2) -2 Rounds -2.5 down to nearest multiple of -2
4 =FLOOR(-2.5,2) -4 Rounds -2.5 down to nearest multiple of 2. The positive significance with the negative number rounds away from zero

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if one or both of the supplied arguments is non-numeric
#NUM! Occurs if either:

  In Excel 2010 or
Excel 2013:
the supplied number is positive and the supplied significance is negative
  In Excel 2007 or
earlier:
the supplied significance value has a different arithmetic sign to the supplied number argument
#DIV/0! Occurs if the supplied significance argument = 0