FLOOR.MATH Function Explained
The FLOOR.MATH Function in Microsoft Excel rounds a number down to the nearest multiple of a specified significance. It takes two arguments: the number to be rounded and the multiple to which it should be rounded. For example, FLOOR.MATH(7.5, 0.5) would return 7.0.
FLOOR.MATH Function Syntax
FLOOR.MATH(number, significance, [mode])
- number: The number you want to round down to the nearest multiple of significance.
- significance: The multiple to which you want to round down number.
- mode: (optional) A number that specifies the type of rounding. If mode is omitted, it is assumed to be 0.