Md. Abdullah Al Murad
Rounding is necessary when we deal with numbers. In Excel, we can easily round numbers to any specific value using different functions. In this article, I will show how to round numbers to the nearest 10000 in Excel.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
5 Easy Ways to Round Numbers to Nearest 10000 in Excel
There are various ways we can round a number to its nearest 10000 in Excel. Here I will show 5 easy and simple ways of rounding numbers to the nearest 10000 in Excel. For illustration purposes, I have taken a dataset below. It contains 7 numbers.
Now, our goal is to round off those numbers to the nearest 10000. We will show 5 different methods. Let’s begin with our first method.
1. Using ROUND Function to Round to Nearest 10000
As the heading suggests, in this method, we will use the ROUND function to round numbers to nearest 10000. Before going to the example, let’s talk about the ROUND Function first. The syntax of the function is like this:
ROUND (number, num_digits)In the first portion, it takes the number which you want to round. For this, we will need to pass the cell number of that number. Then in the second portion, it takes the number digit, meaning up to the number of digits to which number should be rounded. There are three possible ways to declare rounding behavior. They are:
| >0 (Positive Numbers) | Round to nearest .1, .01, .001, .0001 etc. |
| <0 (Negative Numbers) | Round to nearest 10, 100, 1000, 10000, etc. |
| =0 | Round to nearest 1. |
As we have got familiar with the ROUND function, let’s follow the steps below to apply the function.
Steps:
- Enter the formula in cell C5.
=ROUND(B5,-4)
- Now, use the Fill Handle to Copy down the formula up to C11.
- As a result, we will get our final rounded result.
🔎 How Does the Formula Work?
In this formula, firstly I have initially passed the desired cell number where the number is located which is B5. Then as we want to round nearest to 10000 that’s why in the second portion, it is -4.
Read More: How to Round to Nearest 100 in Excel (6 Quickest Ways)
2. Utilizing ROUNDUP Function to Round to the Nearest 10000
Another rounding function is the ROUNDUP function. This function allows us to round up any number to the nearest 10000s when the number itself is higher than the midpoint in the range of 10000s. To illustrate, we have taken another set of numbers where every number is higher than the midpoint in the range of 10000s.
Now, we will use the ROUNDUP function to round them. But before that, let’s introduce ourselves with the syntax of the functions.
ROUNDUP (number, num_digits)
This is like the ROUND function. First, we need to pass the number which we want to round then the number of digits to which the number should be rounded up.
[ Note it will find out the highest possible round number from the current position. ]
Now follow the steps below to apply the function.
Steps:
- Enter the formula in cell C5.
=ROUNDUP(B5,-4)
- Using the Fill Handle, copy down the formula up to C11.
Read More: How to Round up Decimals in Excel (5 Simple Ways)
3. Applying ROUNDDOWN Function to Round to the Nearest 10000
Like the above two methods, we can do the same thing using the ROUNDDOWN function. This function allows us to round down any number to the nearest 10000s when the number itself is lower than the midpoint in the range of 10000s. To illustrate, we have taken another set of numbers where every number is lower than the midpoint in the range of 10000s.
Now, I will show how to round numbers using this function. The syntax of the function is like this:
ROUNDDOWN(number, num_digits)Here firstly we will pass the number you want to round down and then pass the positive numbers, negative numbers, or 0 depending on the number of digits to which you want to round the number
[ Note it will find out the lowest possible round number from the current position. ]
Now, follow the steps below to apply the function.
Steps:
- Enter the formula in cell C5.
=ROUNDDOWN(B5,-4)
- Copy down the formula up to C11.
Read More: How to Round Numbers in Excel Without Formula (3 Quick Ways)
Similar Readings
- How to Change International Number Format in Excel (4 Examples)
- [Solved:] Long Numbers Are Displayed Incorrectly in Excel
- How to Display Long Numbers in Excel (4 Easy Ways)
- Custom Cell Format Number with Text in Excel (4 Ways)
- How to Format a Number in Thousands K and Millions M in Excel (4 Ways)
4. Applying CEILING and FLOOR Functions to Round to the Nearest 10000
Let’s see how to round using the CEILING and the FLOOR functions in Excel. Basically, it is the alternative of the above two functions which are the ROUNDUP and ROUNDDOWN functions. First, let’s look at the functions.
4.1 Applying CEILING Function
The syntax of the CEILING function is like this:
CEILING (number, significance)This is the same as the previous ROUNDUP function. It also takes the desired number which will be rounded first and then the significance value. But it will round the highest possible round value as much as it can. Hence, we have taken the same dataset as in the case of the ROUNDUP function. Now, follow the steps below.
Steps:
- Enter the formula in cell C5.
=CEILING(B5,10000)
- Copy down the formula up to C11.
🔎 How Does the Formula Work?
In this function firstly, I have passed the cell number (B5) where our number is located. Then as we want to round to the nearest 10000, that’s why I have passed 10000 in the second portion. This will round up to the nearest highest 10000 as much as can.
4.2 Applying FLOOR Function
The syntax of the FLOOR function is like this:
FLOOR (number, significance)This is the basic structure of this function. In the first portion, it takes the number which is going to be rounded. Then the second portion contains the multiple to which you want to round. But it will round the lowest possible round value as much as it can. As it acts the same way as the ROUNDDOWN function, we have taken the same dataset in this case also. Now, follow the steps below.
Steps:
- Enter the formula using the FLOOR function in cell C5.
=FLOOR(B5,10000)
- Copy down the formula up to C11.
🔎 How Does the Formula Work?
In this function firstly, I have passed the cell number (C5) where our number is located. Then as we want to round to the nearest 10000, that’s why I have passed 10000 in the second portion. This will round up to the nearest lowest 10000 as much as can.
Read More: How to Round to Nearest 1000 in Excel (7 Easy Methods)
5. Using MROUND Function to Round to the Nearest 10000
Lastly, let’s see how to round numbers using the nearest multiple. For this, we will use another Excel build-in function which is the MROUND function. Here, we will consider the same example taken in the case of the ROUND function above.
First look at the function definitions. The syntax of the function is like this:
MROUND (number, multiple)The first portion carries the value you want to round and the second portion is the multiple values which you want to round the number. Now to apply the function, follow the steps below.
Steps:
- Enter the formula in cell C5.
=MROUND(C5,10000)
- Then, copy down the formula up to C11.
🔎 How Does the Formula Work?
As with the previous functions, firstly the number we want to round is in the A5 cell. Then the multiple value is 10000 as we want to find out the round to the nearest 10000.
Read More: How to Round Numbers to the Nearest Multiple of 5 in Excel
Conclusion
These are the ways to round numbers to the nearest 10000 in Excel. I have shown all the methods with their respective examples. Also, I have discussed the fundamentals of this function and the most commonly used format codes of this function. If you have any other method of achieving this then please feel free to share it with us.
