FLOOR.MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance
Syntax
FLOOR.MATH(number, [significance], [mode])
Parameters
- number: Required. The value you want to round
- significance: Optional. The multiple to which you want to round
- mode: Optional. The direction to round negative numbers
Example
=FLOOR.MATH(6.7)