In Excel, we can round the values with the normal ROUND function. Have you ever tried to round the number that is closest to the multiple of 1000s? Here I introduce some formulas to finish this job in Excel. You can also use this formula to round the numbers to the nearest 1000s /100s /10s /1s/0.1s. 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:
- Use the below formula to round the numbers to the nearest 1000s.
=ROUND(number,-3)
Syntax Explanations:
- ROUND – This function will help to round a number to the specified number of digits. Read more on the ROUND Function.
- Number – It represents the input values from your worksheet.
- 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.
Example:
Refer to the below example image.
- First, we will enter the input values in Column B.
- Here we want to round up the values to the nearest 1000s.
- 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.
Closure:
So yeah guys this is how you can round the values to the nearest 1000s in Excel. If you know of any other alternative methods, let me know in the below comment section. Don’t forget to share your worthwhile feedback with us. Thank you so much for visiting our site. To learn more, check out *Geek Excel **and Excel Formulas *!! **
Top comments (0)