FLOOR.MATH function
Summary
Rounds a number down, to the nearest integer or to the nearest multiple of significance
Syntax
FLOOR.MATH(number, significance, mode)
The FLOOR.MATH function syntax has the following arguments.
• Number Required. The number to be rounded down.
• Significance Optional. The multiple to which you want to round.
• Mode Optional. The direction (toward or away from 0) to round negative numbers.
• Number Required. The number to be rounded down.
• Significance Optional. The multiple to which you want to round.
• Mode Optional. The direction (toward or away from 0) to round negative numbers.
Example
=FLOOR.MATH(24.3,5)
=FLOOR.MATH(6.7)
=FLOOR.MATH(-8.1,2)
=FLOOR.MATH(-5.5,2,-1)
=FLOOR.MATH(6.7)
=FLOOR.MATH(-8.1,2)
=FLOOR.MATH(-5.5,2,-1)