FLOOR

Rounds a number down towards zero to the nearest specified multiple, ensuring values align with defined increments or limits.

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

Syntax

FLOOR(value, significance)

Arguments

value - Number or reference (Required).

significance - Multiple to which the number should be rounded. If missing, the number is rounded to the nearest integer less than the number (optional).

Example

FLOOR(COLUMN)

In the example below, the FLOOR Values measure is created using the FLOOR function, which returns the rounded-off values of the numbers toward zero.

Applying FLOOR function

Excel Equivalent

FLOOR