Rounds a number down, toward zero.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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.
=ROUNDDOWN(3.14159, 3)Résultat : 3.141
Rounds 3.14159 down to three decimal places.
=ROUNDDOWN(314.159, -1)Résultat : 310
Rounds 314.159 down to the nearest ten.
ROUND rounds to the nearest value (up or down), while ROUNDDOWN always rounds toward zero.