The FLOOR.PRECISE function rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.

FLOOR.PRECISE takes 1 required argument and 1 optional argument:

Syntax: FLOOR.PRECISE(number, [significance])

#1)
Using the FLOOR.PRECISE function:
Note:
See also the FLOOR function.
#2)
The arguments for the FLOOR.PRECISE function are:
Argument Required? Description
number Required The value to be rounded.
significance Optional The multiple to which number is to be rounded. If significance is omitted, its default value is 1.
#3)
One thing:
The absolute value of the multiple is used, so that the FLOOR.PRECISE function returns the mathematical floor irrespective of the signs of number and significance.

Summary

The FLOOR.PRECISE function rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.
comments powered by Disqus