Función de Google Sheets

MROUND

Returns a number rounded to the nearest specified multiple.

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

MROUND(number, multiple)

MROUND rounds a number up or down to the nearest multiple of the provided argument. If the remainder of dividing the number by the multiple is greater than or equal to half the value of the multiple, the function rounds away from zero.

Argumentos

numberobligatorioThe value you want to round.
multipleobligatorioThe multiple to which you want to round the number.

Ejemplos

=MROUND(10, 3)

Resultado: 9

10 is rounded to the nearest multiple of 3, which is 9.

=MROUND(11, 3)

Resultado: 12

11 is rounded to the nearest multiple of 3, which is 12.

Preguntas frecuentes

What happens if the number and multiple have different signs?

MROUND will return a #NUM! error if the number and multiple have different signs.

Funciones relacionadas

ROUND ROUNDUP ROUNDDOWN CEILING FLOOR