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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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.

excel round down to 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.

excel round down to nearest 10

  • 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 (8 Easy Methods)


Similar Readings


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)

excel round down to nearest 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.

excel round down to nearest 10

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

Read More: Excel VBA: Round to Nearest 5 (Macro and UDF)


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)

excel round down to nearest 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.

excel round down to nearest 10

Read More: How to Round Down to Nearest Whole Number in Excel (4 Methods)


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

Leave a reply

ExcelDemy
Logo