# Round Down to Nearest 10 in Excel (3 Effective Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to round down a number to the nearest 10 while working in Excel., we can apply various methods. In this article, I am going to show you 3 effective methods in Excel to round down a number to the nearest 10.

## How to Round Down to Nearest 10 in Excel: 3 Suitable Methods

This is the dataset that I am going to use. There are some numbers that I am going to convert to the nearest 10.

### 1. Apply ROUNDDOWN Function to Round Down to Nearest 10

In this segment, I am going to use the ROUNDDOWN function to round down to the nearest 10.

Steps:

• Select Cell C5. Write down the formula
`=ROUNDDOWN(B5,-1)`

Here -1 in the argument means that the number will be rounded down to the nearest 10.

• Press ENTER. Excel will return the output.

• Now use the Fill Handle to AutoFill till C11.

Note: In the case of the negative numbers, the ROUNDDOWN function moves toward 0.

Read More: Round to Nearest 5 or 9 in Excel

### 2. Use FLOOR Function to Round Down to Nearest 10

Now, I will use another function called the FLOOR function to round down to the nearest 10.

Steps:

• Select Cell C5. Write down the formula
`=FLOOR(B5,10)`

Here 10 in the argument means that the number will be rounded down to the nearest 10.

• Press ENTER. Excel will return the output.

• Now use the Fill Handle to AutoFill till C11.

Note: In the case of the negative numbers, the FLOOR Function moves away from 0.

Read More: Excel VBA: Round to Nearest 5

### 3. Perform MROUND Function to Round Down to Nearest 10

Now I will demonstrate how to round down to the nearest 10 using the MROUND function. For this purpose, I have modified the dataset a little.

Steps:

• Select Cell C5. Write down the formula
`=MROUND(B5,10)`

Here 10 in the argument returns the number to the nearest multiple of 10.

• Press ENTER. Excel will return the output.

• Now use the Fill Handle to AutoFill till C11.

## Things to Remember

• The function MROUND can also round up a number. Since all the numbers in our dataset have less than 5 at the unit place, we get the numbers rounded down.

## Conclusion

In this article, I have illustrated 3 effective methods in Excel to round down a number to the nearest 10. I hope it helps everyone. And lastly, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF