It returns a number rounded down, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the FLOOR function.
The syntax of the function is the following:
FLOOR.MATH(number, [significance], [mode])
number: The number we need to round down.
[significance]: Optional. The multiple of significance we wish to round down to.
[mode]: Optional. It controls if the number will be rounded toward or away from zero.
The default value of significance is +1 for positive numbers and -1 for negative numbers.
The mode argument does not affect positive numbers