FLOOR.MATH FunctionWayne Becker20150926T21:28:41+00:00
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 nonzero [mode], which reverses rounding direction 
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if any of the supplied arguments are nonnumeric 