FLOOR

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

Syntax FLOOR (number, significance )

Argument	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 towards zero. If number is an exact multiple of significance, no rounding occurs.

If number or significance is non-numeric, #NAME? 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, EVEN, INT, ODD, ROUND, TRUNC