FLOOR

Description

Rounds a number down to the nearest multiple of a specified significance.

Syntax

FLOOR ( number, significance )

Parameter Description
number The value to round.
significance The multiple to which to round.

Remarks

Regardless of the sign of the number, the value is rounded down, toward zero. If number is an exact multiple of significance, no rounding occurs.

If number or significance is non-numeric, #VALUE! is returned. When the arguments have opposite signs, #NUM! is returned.

Examples

This function returns 1.2:

FLOOR(1.23459, .05)

This function returns -148:

FLOOR(-148.24, -2)

See also

CEILING

INT

ROUND

TRUNC