Función de Google Sheets

CEILING

Rounds a number up to the nearest integer or 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

CEILING(number, significance)

The CEILING function rounds a given number away from zero to the nearest multiple of the specified significance. It is commonly used for pricing or inventory calculations where values must be rounded up to a specific unit.

Argumentos

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

Ejemplos

=CEILING(2.5, 1)

Resultado: 3

Rounds 2.5 up to the nearest multiple of 1.

=CEILING(10, 3)

Resultado: 12

Rounds 10 up to the nearest multiple of 3, which is 12.

Preguntas frecuentes

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

The function returns the number unchanged.

Does CEILING work with negative numbers?

Yes, but it rounds away from zero, meaning it becomes more negative.

Funciones relacionadas

FLOOR ROUNDUP ROUND