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 **10000**s. To illustrate, we have taken another set of numbers where every number is higher than the midpoint in the range of **10000**s.

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 **10000**s when the number itself is lower than the midpoint in the range of **10000**s. To illustrate, we have taken another set of numbers where every number is lower than the midpoint in the range of **10000**s.

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**C****5**.

`=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.