Excel ROUND Function: Sometimes, we want to round the numbers when they have huge digits in them. Doing this manually will take time to finish the work. For that, we suggest you use the ROUND function in the worksheet. This function returns a number rounded to a given number of digits.
In this article, we will see how to use the Excel ROUND Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Explanation of ROUND Function
- It is one of the built-in functions in Microsoft Excel.
- This function rounds a number to the specified number of digits.
- For example, ROUND(3.18302, 2) returns the output value of 3.18
Syntax
- Here, you will see the syntax of the ROUND 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.
=ROUND(number, num_digits)
Argument Explanation:
- Number – The input number that needs to be rounded.
- Num_digits – The number of digits by which you want to round the given number.
Note:
1) If num_digits is greater than 0, It will round the number to the specified number of decimal places.
2) It will round the number to the nearest integer if num_digits is 0.
3) If num_digits is less than 0 and then it will round 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.
5) If the floating-point value is greater than or equal to 5 and then this ROUND function will add number 1 to the decimal value and print the rounded output. For example, ROUND(14567.89, -3) will return the value of 15000.
Examples
Let’s see some examples to understand this function easily.
- Here, you can see the input numbers in Column A, and their specified digits in Column B.
- Apply the above-mentioned formula. The rounded output 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.
- If any argument is a non-numeric value such as letters, or special characters and then it will return #VALUE! Error.
Closure
In the above article, you can clearly understand the usage of the Excel ROUND Function with its syntax, explanation, and examples. Drop your queries/suggestions in the below 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 ROUND function in the spreadsheet.
Read Also:
- 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?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.
