Round down to a specified number of digits.

`=ROUNDDOWN(number,num_digits)`

- number - the number to truncate
- num_digits - [REQUIRED] the place where to round number

`=ROUNDDOWN(3.9,0)`

rounds 3.9 down to the nearest whole number, which is 3.`=ROUNDDOWN(A1,1)`

rounds down to the nearest decimal place. For example, if A1 is 3.75, the result would be 3.7.`=ROUNDDOWN(A1,2)`

rounds down to the nearest two decimal places. For example, if A1 is 3.753, the result would be 3.75.`=ROUNDDOWN(A1,0)`

rounds down to the nearest one. For example, if A1 is 3.4, the result would be 3.`=ROUNDDOWN(A1,-1)`

rounds down to the nearest ten. For example, if A1 is 23.4, the result would be 20.

The ROUNDDOWN function is a useful tool for rounding a number down to its nearest whole number, percentage, or other number. It takes one argument, the number to be rounded down.

- The ROUNDDOWN function takes two arguments: number and num_digits. The number argument is the number to truncate and the num_digits argument is the place to round down to the nearest integer.
- ROUNDDOWN rounds all numbers down to the nearest whole number.

The ROUNDDOWN function is a mathematical function that rounds a number down towards zero. The ROUNDDOWN function always rounds a number down to the nearest integer, regardless of the number of decimal places.

The ROUNDDOWN function works by rounding a number down to the specified number of decimal places if the num_digits parameter is greater than 0. If the num_digits parameter is less than or equal to 0, the ROUNDDOWN function will round a number down to the nearest integer.

If the num_digits parameter is less than 0, the ROUNDDOWN function will round a number down to the nearest integer.

Drop CSV