In this article, I am going to cover how to use Excel ROUNDDOWN function. You will also explore the syntax and examples of ROUNDDOWN.

The Excel ROUNDDOWN function rounds a number down toward zero to a given number of decimal places. ROUNDDOWN can either round to the left or right of the decimal point. Unlike typical rounding (where numbers less than 5 are only rounded down), ROUNDDOWN rounds all the numbers 1-9 down.

**Uses: Excel ROUNDDOWN Function**

Excel ROUNDDOWN is opposite of what ROUNDUP function does, i.e. rounding a number down, closer to zero. The function works exactly same as like Excel INT function, but it rounds a number down, towards zero with choice to have the number of decimal places you want in final answer.

**Syntax:**

Following is the syntax of the Excel ROUNDDOWN function:

*ROUNDDOWN (number, num_digits)*

**Arguments:**

**number**: the number to be rounded.**num_digits**: the number of digits to round the number to.

**Examples: Excel ROUNDDOWN Function **

The following examples given in column C in below screenshot show, how to make a use of ROUNDDOWN function.

Note that, number in cell A4 (-17.24892) is rounded to the nearest integer, closest to zero. Unlike ROUNDUP function, where the numbers above 0 are rounded up, ROUNDDOWN rounds all the numbers 1-9 down; hence cell C5 returned the cell with 1200.

**Additional Notes: –**

- ROUNDDOWN does opposite of what ROUNDUP function does, always rounding a number down.
- If
**num_digit**is 0, the**number**is rounded down to the nearest integer. - If
**num_digit**is below 0, the number is rounded down to the left of the decimal point (i.e. to the nearest tenth, hundredth, thousandth, etc.). - The arguments can be a number, reference to a cell containing numbers or numbers returned by some formula.
- Same as like ROUND & ROUNUP, ROUNDDOWN also does not accept ‘text’ as part of any arguments. When supplied, the function throws #VALUE! error.
- The answer returned by ROUNDDOWN always remain in the same sign as the
**number** - ROUNDDOWN always round the numbers 1-9 down.
- The ROUNDDOWN function can round either to the right or left of the decimal point.
- If
**num_digit**is above zero (0), the**number**is rounded down to the specified number of decimal places to the right of decimal point without any changes in the rounding digit.

- If

**Related Tips:-**