# How to use Excel ROUNDDOWN Function

0
999

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.