Sometimes we need to make a round to the nearest 100 in** Excel**. In this article, we are going to show you how to make a round to the nearest 100 in **Excel** in 1 swift approach. We have also included some relevant concerns at the end of this article. So let’s get started.

## 📂 Download Excel File

Download the free workbook from here:

## Learn How to Round to Nearest 100 in Excel with 6 Different Functions

While writing this article, “**Excel **Round to Nearest 100”. We’ve considered a dataset that contains approximately **4** columns and **11** rows. In this dataset, we added** Name**, **Points, **and **Points (Rounded)** to make you better understand. But if you want, you can change the entities and put the values of your own.

There are many functions in **Excel**. You can make a round to the nearest 100 by utilizing these functions. We are going to show you some of them in **Excel **round to the nearest 100.

**UTILIZING EXCEL FUNCTIONS**

### 1. Application of ROUND Function

If you want an **Excel** round to the nearest 100, then you can use the **ROUND Function**. You just need to maintain the following steps.

** ⬇️⬇️ STEPS ⬇️⬇️**

- Firstly, select the
**D6** - Secondly, write down the following function there:

**=ROUND(C6,-2)**

- Finally, tap
**Enter**and drag down with**Fill Handle**.

- Eventually, you will get the values round to the nearest 100.

Truly, using the **ROUND **function in **Excel **to round to the nearest 100 is a very simple method.

**UTILIZING EXCEL FUNCTIONS**

### 2. Using ROUNDDOWN Function

Another function to round to the nearest 100 in **Excel **is the **ROUNDDOWN **function. It will get the values downward to the given numbers. You can achieve this by following the given steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- Initially, select cell
**D6**. - Then write the following function there:

**=ROUNDDOWN(C6,-2)**

- Finally, tap
**Enter**.

- Consequently, you will see all the values round to the nearest 100.

Indeed, using the **ROUNDDOWN Function** is one of the easiest ways to round to nearest 100 in **Excel**.

**UTILIZING EXCEL FUNCTIONS**

### 3. Adopting ROUNDUP Function

This is also a function that we know as **ROUNDUP Function**. This function will make you number upward to the given values. You can obtain this method by following the below steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- Primarily, select cell
**D6**. - Secondly, write the following function in that cell

**=ROUNDUP(C6,-2)**

- Now press
**Enter**.

- Finally, you will get all values round to the nearest 100 (upward) as required.

Eventually, this is a very simple function to round to the nearest 100 in **Excel**.

**UTILIZING EXCEL FUNCTIONS**

### 4. Applying CEILING Function

You can use the **CEILING Function** to round to the nearest 100 in **Excel**. This function will give value based on significance.

** ⬇️⬇️ STEPS ⬇️⬇️**

- Initially, you need to select cell
**D6**. - Secondly, you have to write that function in the particular cell.

**=CEILING(C6,100)**

- Now press
**Enter**.

- Consequently, you will get all the values round to the nearest 100 in upward order as you wish.

Sincerely, utilizing the **CEILING **function is very handy to round to the nearest 100 in **Excel**.

**UTILIZING EXCEL FUNCTIONS**

### 5. Using FLOOR Function

If want to round to the nearest 100 in **Excel**, then you can also use the **FLOOR Function**. It will give us the values just like the **ROUNDDOWN **function. You need to maintain the following steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- Firstly, select cell
**D6**. - Then put the given function there.

**=FLOOR(C6,100)**

- Now press
**Enter**. - Finally, you will get the values round to nearest 100 (downward) as you wanted.

Undoubtedly, you can easily use this function to round to nearest 100 in **Excel**.

**UTILIZING EXCEL FUNCTIONS**

### 6. Considering MROUND Function

Another similarity to the **ROUND **function is **MROUND Function**. You just need to maintain the given steps to achieve this function.

**⬇️⬇️ STEPS ⬇️⬇️**

- Initially, click and select the
**D6** - Now write the function on that cell.

**=MROUND(C6,100)**

- Now tap
**Enter**.

- Lastly, you can have the values round to nearest 100 as you wanted.

Truly, using this function is very useful to round to nearest 100 in **Excel**.

## Round to Nearest Whole Number in Excel

If you want to round to nearest whole number in **Excel**, then this portion is for you.

**⬇️⬇️ STEPS ⬇️⬇️**

- Firstly, go to the
**Whole Number**. - Secondly, select cell
**D6**. - Thirdly, put the following function there.

**=INT(C6)**

- Now hit
**Enter**.

- Finally, you will get all the values as a whole number and there will be no decimal number.

Undoubtedly, this is a very handy function to round to nearest whole number in **Excel**. You can also find this as – **How to Round a Decimal to an Integer in Excel**.

## How to Round to Nearest 50 in Excel

There is also a feature in **Excel **by which you can round to nearest 50. It is very important while doing any mathematical calculations. You can do this by maintaining the following steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- Firstly, go to the
**Round to 50** - Secondly, select cell
**D6**. - Thirdly, write the following function there.

**=ROUND(C6/50,0)*50**

**🔨 Formula Breakdown**

It indicates:

** C6 **is the cell whose number we want to round.

** 50** is the **Significance **of the round number.

** 0 **(**zero**) means we don’t want decimals.

- Lastly, press
**Enter**. - Consequently, you will get the values just like the below picture.

Truly, this is a very easy way to round to the nearest 50.

## How to Round to Nearest 1000 in Excel

If you want to round to the nearest 1000 in **Excel**, then this portion is for you. You can do this by maintaining the below steps.

**⬇️⬇️ STEPS ⬇️⬇️**

- Initially, select the required cell.
- Then write the given function.

**=ROUND(C6/1000,0)*1000**

- Now press
**Enter**.

- Consequently, you will get all the values round to the nearest 1000.

Undoubtedly, this is a very user-friendly function to round to nearest 1000 in **Excel**.

## Using Custom Format to Round Decimal Points in Excel

Basically, there are some approaches to making a round in **Excel**. One of them is using a custom format. You just need to follow the below-mentioned steps.

** ⬇️⬇️ STEPS ⬇️⬇️ **

- Firstly, select cells
**C6**to**C11**. - Secondly, go to the
**Home**tab. - Thirdly, click on
**Alignment Settings**.

- You will get a dialogue box named
**Format Cells**. - When you get the box, select
**Number**from**Category**. - Put
**0 (zero)**to**Decimal places**. **-1234**while selecting**Negative numbers**.- Finally, click on
**OK**.

- Consequently, you will see all the values from cells
**C6**to**C11**are in a round figure.

Undoubtedly, this is a straightforward technique to make a round in **Excel**.

## 📄 Important Notes

While working on the procedures mentioned above you need to be aware of the following things:

`🖊️`

You need to be careful while using **Excel**.

🖊️ When you intend to use the **Custom Format **you should be conscious.

## 📝 Takeaways from This Article

If we summarize the whole article, basically we have got some approaches to round to nearest 100 in **Excel**.

📌 Firstly, we have used different types of **Excel **functions.

**1. ROUND **Function.

**2. ROUNDDOWN **Function.

**3. ROUNDUP **Function.

**4. CEILING **Function.

**5. FLOOR **Function.

**6. MROUND **Function.

`📌`

Secondly, we’ve tried to show you to round to the **Nearest Whole Number **in **Excel**.

📌 Thirdly, we’ve shown you to round to **Nearest 50 **in **Excel**.

`📌`

Fourthly, ** ** we’ve tried to show you to round to **Nearest 1000 **in **Excel**.

📌 Finally, we have used **Custom Format **to round ** **in **Excel**.

## Conclusion

We wish that you would be able to round to the nearest 100 in **Excel** using this article. As several methods have been shown here, you can easily follow which one is best suited for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about **Excel** tactics, we recommend you to visit our website **www.ExcelDen.com**.