Excel is a spreadsheet developed by Microsoft. This application will help you to create, view, edit, and share your files with others as soon as possible. It also provides numerous formulas and functions to do mathematical calculations, graphic tools, pivot tables, charts, etc.
Sometimes, you want to round down a large set of numbers. Instead of doing it manually, you can quickly finish this task with the help of the Excel ROUNDDOWN Function. It will round a number down to the specified number of digits towards zero.
In this post, we are going to learn how to use Excel ROUNDDOWN Function with its syntax, definition, and examples. Get an official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Jump To
Definition of ROUNDDOWN Function
- It is one of the built-in functions in Microsoft Excel.
- This function rounds a number down to the specified number of digits toward zero.
- For example, ROUNDDOWN(1.2345, 3) will return the output value of 1.234
Syntax
- Here, you will see the syntax of the ROUNDDOWN function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
=ROUNDDOWN(number, num_digits)
Argument Explanation:
- Number – The number that needs to be rounded.
- Num_digits – The number of digits by which the input number should be rounded.
- If the Digit value is positive, then it will round the value to the right of the decimal number. If the Digit value is negative and then it will round the value to the left of the decimal number. Kindly refer to the Digit Value and its Behavior Table.
| Digit Value | Result of ROUNDDOWN Function |
|---|---|
| >0 | This function will round down the nearest value “0.1, 0.01, 0.001, 0.0001“ |
| 0 | This function will round down to the nearest Whole number (1) |
| <0 | This function will round down the nearest value “10, 100, 1000, 10000“ |
Note:
1) If num_digits is greater than 0, It will round down (towards zero) the number to the specified number of decimal places.
2) It will round down the number to the nearest integer if num_digits is 0.
3) If num_digits is less than 0 and then it will round down the number to the left of the decimal point.
4) If any argument is a non-numeric value such as letters, special characters and then it will return #VALUE! Error.
Excel ROUNDDOWN Function
Here, we have given some examples for your reference.
- The input numbers are given in Column B, and the digits are specified in Column C.
- Apply the above-mentioned formula. Then, the rounded-down values are listed in Column C.
- Finally, we need to click on the Enter button to get the result. Drag-down the first cell to fill the remaining cells.
Input that Causes Error
- If any argument is a non-numeric value such as letters, or special characters, then it will return #VALUE! Error.
Verdict
In this post, you can clearly understand the usage of the Excel ROUNDDOWN Function with its syntax, definition, and examples. Leave your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
The following video will show you how to use the Excel ROUNDDOWN function in the spreadsheet.
Read Ahead:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!
