Navigation:  Formulas and functions > Functions from A to Z > FLOOR (round down to a multiple of base)

Syntax:

FLOOR(Number, Base)

Description:

This rounds Number down (towards zero) to the nearest multiple of Base.

Positive numbers are rounded to the nearest multiple of Base that is smaller than Number.

Negative numbers are rounded to the nearest multiple of Base that is larger than Number.

Number and Base must have the same sign, otherwise the function returns a #NUM! error value.

Example:

FLOOR(42.5, 1) returns 42

FLOOR(-42.5, -1) returns -42

FLOOR(21, 5) returns 20

FLOOR(12.3456, 0.01) returns 12.34

See also:

CEILING, ROUNDDOWN, ROUNDUP, ROUND, MROUND, TRUNC