Función de Google Sheets

FLOOR

Rounds a number down to the nearest multiple of significance.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

FLOOR(number, significance)

The FLOOR function rounds a number down, toward zero, to the nearest multiple of the specified significance. It is commonly used for rounding prices or quantities to a specific increment.

Argumentos

numberobligatorioThe numeric value you want to round.
significanceobligatorioThe multiple to which you want to round.

Ejemplos

=FLOOR(2.5, 1)

Resultado: 2

Rounds 2.5 down to the nearest multiple of 1.

=FLOOR(17, 5)

Resultado: 15

Rounds 17 down to the nearest multiple of 5.

Preguntas frecuentes

What happens if the number is already a multiple of significance?

The function returns the number unchanged.

Can I use negative numbers with FLOOR?

Yes, but the rounding behavior depends on the sign of the number and the significance.

Funciones relacionadas

CEILING ROUND INT