FLOOR

See also A-Z Spreadsheet Function List

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

Syntax FLOOR(number, significance)

number is the value to round.

significance is 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, #NAME? is returned. When the arguments have opposite signs, #NUM! is returned.

See Also CEILING , EVEN , INT , ODD , ROUND , and TRUNC functions

Examples FLOOR(1.23459, .05) returns 1.2

         FLOOR(-148.24, -2) returns -148