Funzione di Google Sheets

ROUNDDOWN

Rounds a number down, toward zero.

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

ROUNDDOWN(number, num_digits)

The ROUNDDOWN function behaves like ROUND, except that it always rounds a number down. If num_digits is greater than 0, the number is rounded down to the specified number of decimal places; if it is 0 or negative, it rounds toward zero to the left of the decimal point.

Argomenti

numberobbligatorioThe real number that you want to round down.
num_digitsobbligatorioThe number of digits to which you want to round the number.

Esempi

=ROUNDDOWN(3.14159, 3)

Risultato: 3.141

Rounds 3.14159 down to three decimal places.

=ROUNDDOWN(314.159, -1)

Risultato: 310

Rounds 314.159 down to the nearest ten.

Domande frequenti

How does ROUNDDOWN differ from ROUND?

ROUND rounds to the nearest value (up or down), while ROUNDDOWN always rounds toward zero.

Funzioni correlate

ROUND ROUNDUP FLOOR TRUNC