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

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.

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

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.

### 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.

### 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.

## Related Articles #### Akib

We will be happy to hear your thoughts 