Microsoft Excel offers a few different options for rounding numbers. The most generally useful and versatile of these is the ROUND function. In this chapter, we illustrate the simple tricks to round a number in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- If you want to round a number up or down to the nearest specified digit, use the below formula.
=ROUND(number,digits)
Syntax Explanations:
- ROUND – In Excel, the ROUND function will help to round a number to the specified number of digits.
- Number – It represents the input values from your worksheet.
- Digits – This is the value that specifies how many digits to be rounded.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Refer to the below example image.
- First, we will enter the input values in Column B.
- Here, we need to round up or down the number based on the digits which are given in Column C.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
Conclusion:
Hope you like this article on how to round numbers in Excel. If you have any other ideas or question , do share with us here in the comments section below. Thank you. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)