ROUNDDOWN Function in Excel (Table of Contents)
ROUNDDOWN in Excel
ROUNDDOWN Function is an inbuilt function in excel that is categorized under MATH & TRIG function. It is used as worksheet & VBA function in excel
Sometimes numbers appearance with more decimal points doesn’t look good. To reduce the number of decimal points Rounddown function is used
The ROUNDDOWN function in Excel is mainly used to reduce a value by a specified number of digits or decimal places in a large number of datasets & it slightly modifies the value of the data in the cell
The ROUNDDOWN function is opposite to that off ROUNDUP function. It is most commonly used in finance domain to improve the accuracy of datasets.
Definition
ROUNDDOWN Function: Rounds a number towards zero. It returns an output number rounded down to a specified or given number of decimal places
ROUNDDOWN Formula in Excel
Below is the ROUNDDOWN Formula:
The ROUNDDOWN function syntax or formula has below-mentioned arguments:
number: It is the number that you want to round down. It is compulsory & required argument
It can be entered as a cell reference, number, function or formula
num_digits: It is the number of digits to which number should be rounded down
or
We have to specify how many units (decimal places) you want to round it to
Prior to applying round down function, you should be aware of how to determine the number of digits? Suppose I have a number 950.134
9 5 0 . 1 3 4
| Hundreds | Tens | ones | Tenth | Hundredth | Thousandth |
Place value towards Left-hand side data is called as ones, tens & hundreds. Whereas place value after a decimal point, i.e. towards the right is called Tenth, Hundredth & Thousandth
How to use ROUNDDOWN Function in Excel?
ROUNDDOWN Function is very simple to use. Let us now see how to use ROUNDDOWN function in Excel with the help of some examples.
ROUNDDOWN in Excel – Example #1
Round down a number to zero decimal place
In the below-mentioned example, Cell “B9” contains a number with decimal values. i.e. 984.5395, With the help of ROUNDDOWN function, I need to round down a number to zero decimal value in the cell “C9”
Let’s apply ROUNDDOWN function in cell “C9”. Select the cell “C9” where the ROUNDDOWN function needs to be applied.
Click the insert function button (fx) under formula toolbar, a dialog box will appear, Type the keyword “ROUNDDOWN” in the search for a function box, a ROUNDDOWN function will appear in select a function box. Double click on a ROUNDDOWN function.
A dialog box appears where arguments for ROUNDDOWN function needs to be filled or entered
i.e. =ROUNDDOWN(number, num_digits)
number: It is the number that I want to round down. Here either 984.5395 or B9 cell reference is entered to get the desired output. Here I mentioned the reference cell i.e. “B9”
num_digits: I want the number with zero decimal value. I have to enter “0” or it can be left blank. Note: by default, if we don’t enter any value. it takes zero
Click ok, after entering both the arguments.
Here =ROUNDDOWN(B9,0) formula results in or Rounds 984.5395 down to a number with zero decimal value i.e. 984
ROUNDDOWN in Excel – Example #2
Round down a number to two decimal places
In the below-mentioned example, Cell “G9” contains a number with decimal values. i.e. 984.5395, With the help of ROUNDDOWN function, I need to round down a number to two decimal value in the cell “H9”
Let’s apply ROUNDDOWN function in cell “H9”. Select the cell “H9” where a ROUNDDOWN function needs to be applied.
Click the insert function button (fx) under formula toolbar, a dialog box will appear, Type the keyword “ROUNDDOWN” in the search for a function box, a ROUNDDOWN function will appear in select a function box. Double click on a ROUNDDOWN function
A dialog box appears where arguments for ROUNDDOWN function needs to be filled or entered
i.e. =ROUNDDOWN(number, num_digits)
number: It is the number that I want to round down. Here either 984.5395 or G9 cell reference is entered to get the desired output. Here I mentioned the reference cell i.e. “G9”
num_digits: I want the number with two decimal value. I have to enter “2”
Click ok, after entering both the arguments.
Here =ROUNDDOWN(G9,2) formula results in or Rounds 984.5395 down to a number with two decimal value i.e. 984.53
ROUNDDOWN in Excel – Example #3
For a Negative value or Dataset
In the below-mentioned example, Cell “B16” contains a negative number with decimal values. i.e. -984.5395, With the help of ROUNDDOWN function, I need to round down a number to the nearest integer in the cell “C16”
Let’s apply ROUNDDOWN function in cell “C16”. Select the cell “C16”. where a ROUNDDOWN function needs to be applied.
Click the insert function button (fx) under formula toolbar, a dialog box will appear, Type the keyword “ROUNDDOWN” in the search for a function box, a ROUNDDOWN function will appear in select a function box. Double click on a ROUNDDOWN function.
A dialog box appears where arguments for ROUNDDOWN function needs to be filled or entered
i.e. =ROUNDDOWN(number, num_digits)
number: It is the number that I want to round down. Here either -984.5395 or B16 cell reference is entered to get the desired output. Here I mentioned the reference cell i.e. “B16”
num_digits: I have to enter “-2”, I want the number rounded down to the left side of the decimal point
Click ok, after entering both the arguments.
Here =ROUNDDOWN(B16,-2) formula results in or Remove all the decimals in -984.5395 and rounds integer down to the nearest hundred i.e. -900
Things to Remember
A ROUNDDOWN function can round either to the right or left side of the decimal point.
- If the num_digits argument is greater than 0, Then it results in or number is rounded down to the specified number of decimal places to the right of the decimal point.
E.G. =ROUNDDOWN(984.5395,2) returns the value 984.53
- If a num_digits argument is equal to 0, Then it results in or number is rounded down to the nearest integer
E.G. =ROUNDDOWN(984.5395,0) returns the value 984
- If a num_digits argument is lesser than 0, Then it results in or number is rounded down to the left side of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).
E.G. =ROUNDDOWN(-984.5395,-2) returns the value -900
Recommended Articles
This has been a guide to Excel ROUNDDOWN function. Here we discuss the ROUNDDOWN Formula and how to use ROUNDDOWN function in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –
