FLOOR

The FLOOR function rounds a number toward zero to the nearest specified multiple of significance. It accepts numeric values or node references as arguments and returns the rounded result based on the given multiple.

Syntax

FLOOR(value, significance)

Arguments

• value: Number or node reference to round.

• significance (Optional): The multiple to which the number should be rounded. If not specified, the number is rounded down to the nearest integer toward zero.

Return value

Returns the number rounded toward zero to the specified multiple.

Example

FLOOR(Planned Units, 3)

In this example, the FLOOR function is used to create the Rounded Off Units measure, which returns the values in the Planned Units measure rounded down to the nearest multiple of 3.

Excel Equivalent

FLOOR