FLOOR.PRECISE function

The FLOOR.PRECISE function is one of the math and trigonometry functions. It is used to return a number that is rounded down to the nearest integer or to the nearest multiple of significance. The number is always rounded down regardless of its sign.

Syntax

FLOOR.PRECISE(number, [significance])

The FLOOR.PRECISE function has the following arguments:

Argument	Description
number	A number you wish to round down.
significance	A multiple of significance you wish to round down to. It is an optional argument. If it is omitted, the default value of 1 is used. If it is set to zero, the function returns 0.

Notes

How to apply the FLOOR.PRECISE function.

Examples

The figure below displays the result returned by the FLOOR.PRECISE function.