Funzione di Google Sheets

CEILING.MATH

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

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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

CEILING.MATH rounds a number up to the nearest integer or the nearest multiple of significance. Unlike the standard CEILING function, this function provides more control over how negative numbers are rounded using the mode argument.

Argomenti

numberobbligatorioThe number to round.
significancefacoltativoThe multiple to which you want to round. Defaults to 1.
modefacoltativoDetermines the direction of rounding for negative numbers.

Esempi

=CEILING.MATH(22.25, 5)

Risultato: 25

Rounds 22.25 up to the nearest multiple of 5.

=CEILING.MATH(-22.25, 5, 1)

Risultato: -20

Rounds -22.25 towards zero using mode 1.

Domande frequenti

How does CEILING.MATH differ from CEILING?

CEILING.MATH provides a mode parameter for better control over negative number rounding, whereas CEILING is older and less flexible.

Funzioni correlate

CEILING FLOOR.MATH ROUNDUP