The Excel ROUNDDOWN function is used to round a number down to a specified number of digits. For example, round a number down to one decimal place.
The syntax for the ROUNDDOWN function is:
=ROUNDDOWN(number,num_digits)
| Argument | Purpose |
|---|---|
| Number | The number you want to round down |
| num_digits | The number of digits you want to round the number down to. If the num_digits is greater than 0, the number is rounded down to the specified number of decimal points. If the num_digits is 0, the number is rounded down to the nearest integer. If num_digits is less than 0, the number is rounded down to the left of the decimal point |
Below are examples of the ROUNDDOWN function being used to round numbers down to a various number of digits.
| Function | Result |
|---|---|
| =ROUNDDOWN(A1,2) | 5.32 |
| =ROUNDDOWN(A2,0) | 2 |
| =ROUNDDOWN(A3,1) | 4.5 |
| =ROUNDDOWN(A4,-1) | 20 |
