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]) ##### Using the FLOOR.PRECISE function:  Note:
See also the FLOOR function. 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. ##### 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