Google Sheets Function

FLOOR.MATH

Rounds a number down to the nearest integer or to the nearest multiple of significance.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

FLOOR.MATH(number, [significance], [mode])

The FLOOR.MATH function rounds a number down toward zero or away from zero, depending on the mode. It is more flexible than the standard FLOOR function because it allows you to control the rounding direction for negative numbers.

Arguments

numberrequiredThe number you want to round.
significanceoptionalThe multiple to which you want to round. Defaults to 1.
modeoptionalThe direction to round negative numbers (0 or omitted rounds toward negative infinity).

Examples

=FLOOR.MATH(6.7)

Result: 6

Rounds 6.7 down to the nearest integer.

=FLOOR.MATH(-5.2, 2)

Result: -6

Rounds -5.2 down to the nearest multiple of 2.

FAQ

How does FLOOR.MATH differ from FLOOR?

FLOOR.MATH provides a mode argument to control how negative numbers are rounded, whereas FLOOR does not.

Related functions

FLOOR CEILING.MATH ROUNDDOWN MROUND