The FLOOR.PRECISE function rounds down to the nearest multiple of significance.
Formula:
=FLOOR.PRECISE(number, [significance])
Explanations:
– The number is required, a number to be rounded.
– Significance is optional, the multiple to which the number is rounded.
Cautions:
– If the significance is omitted, its default value is 1.