Related Functions:

The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of significance.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=FLOOR.MATH(number,[significance],[mode])

Arguments

Argument Description
number The number to be rounded down
[significance] Optional. The multiple to which you want to round

  If omitted, the [significance] argument takes on the default value 1 (i.e. round down to the nearest integer
  The arithmetic sign of the [significance] argument is ignored
[mode] Optional. The direction, toward or away from 0, to round negative numbers

  If [mode] = 0 (or is omitted), negative numbers are rounded away from zero
  If [mode] = any other numeric value, negative numbers are rounded towards zero

Examples

  A B C
1 Formula Result Notes
2 =FLOOR.MATH(23.4,5) 20 Rounds 24.3 down to the nearest integer that is a multiple of 5
3 =FLOOR.MATH(5.6) 5 Rounds 5.6 down to the nearest integer
4 =FLOOR.MATH(-8.1,2) -10 Rounds -8.1 down, away from 0, to the nearest integer that is a multiple of 2
5 =FLOOR.MATH(-8.1,2,-1) 6 Rounds -8.1 down, toward 0, to the nearest integer that is a multiple of 2, using a non-zero [mode], which reverses rounding direction

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric