FLOOR.PRECISE
Returns a number that is rounded down to the nearest integer or to the nearest multiple of significance
Syntax
FLOOR.PRECISE(number, [significance])
Parameters
- number: Required. The value to be rounded
- significance: Optional. The multiple to which number is to be rounded
Example
=FLOOR.PRECISE(-3.2, -1)