Função do Google Sheets

FLOOR.MATH

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

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

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.

Argumentos

numberobrigatórioThe number you want to round.
significanceopcionalThe multiple to which you want to round. Defaults to 1.
modeopcionalThe direction to round negative numbers (0 or omitted rounds toward negative infinity).

Exemplos

=FLOOR.MATH(6.7)

Resultado: 6

Rounds 6.7 down to the nearest integer.

=FLOOR.MATH(-5.2, 2)

Resultado: -6

Rounds -5.2 down to the nearest multiple of 2.

Perguntas frequentes

How does FLOOR.MATH differ from FLOOR?

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

Funções relacionadas

FLOOR CEILING.MATH ROUNDDOWN MROUND