If you want to round to nearest 10 cents in Excel, this article is for you. Here, we will demonstrate to you 4 methods that will help you to do the task effortlessly.
How to Round to Nearest 10 Cents in Excel: 4 Methods
The following Product List table contains ID No., Item and Price columns. We can see in the Price column the price is up to 2 decimal places. Here, we will use 4 different methods in the Price column to round to the nearest 10 cents. Here, we used Excel 365, you can use any available Excel version.
Method-1: Round to Nearest 10 Cents Using MROUND Function
Here, we will use the MROUND function to round to the nearest 10 cents.
Steps:
➤ First, we will type the following formula in cell E5.
=MROUND(D5,0.1)Formula Breakdown
- Here, MROUND returns a number rounded to the desired multiple.
- D5 is the required value to round.
- 0.1 is multiple to round to the nearest 10 cents.
Therefore, MROUND(D5,0.1) rounds D5 which is 12.57 to the nearest multiple of 0.1 and returns 12.60.
➤ After that, press ENTER.
We can see the result in cell E5.
➤ After that, we will drag down the formula with the Fill Handle tool.
Finally, we can see the result in the column Rounded to 10 Cents.
Read More: How to Round Off to Nearest 50 Cents in Excel
Method-2: Use of FLOOR Function to Round to Nearest 10 Cents
In this method, we will use the FLOOR function to round to the nearest 10 cents.
Steps:
➤ First, we will type the following formula in cell E5.
=FLOOR(D5,0.1)Formula Breakdown
- Here, the FLOOR function rounds numbers down to the nearest multiple of significance.
- D5 contains the number we want to round.
- 0.1 is the multiple to which we want to round.
Therefore, FLOOR(D5,0.1) rounds the value of cell D5 which is 12.57 down to the nearest multiple of 0.1 and returns an output 12.50.
➤ After that, press ENTER.
We can see the result in cell E5.
➤ Afterwards, we will drag down the formula with the Fill Handle tool.
Finally, we can see all the prices rounded to 10 cents in the Rounded to 10 Cents column.
Method-3: Round to Nearest 10 Cents Employing CEILING Function
In this method, we will use the CEILING function to round to the nearest 10 cents.
Steps:
➤ First, we will type the following formula in cell E5.
=CEILING(D5,0.1)Formula Breakdown
- Here, the CEILING function returns a number, rounded up, away from zero to the multiple of nearest significance.
- D5 contains the number we want to round up.
- 0.1 is the multiple to which we want to round.
Therefore, CEILING(D5,0.1) rounds the value in cell D5 which is 12.57 up to the nearest multiple of 0.1, and the result is 12.60.
➤ After that, we will press ENTER.
We can see the result in cell E5.
➤ Afterwards, will drag down the formula with the Fill Handle tool.
Finally, we can see the price is rounded to 10 cents in the Rounded to 10 Cents column.
Read More: Rounding to Nearest Dollar in Excel
Method-4: Using ROUND Function to Round to Nearest 10 Cents
Here, we will use the ROUND function for rounding to the nearest 10 Cents.
Steps:
➤ First, we will type the following formula in cell E5.
=ROUND(D5,0.1)Formula Breakdown
- Here, the ROUND function returns a number to a specified number of digits.
- D5 contains the number that we want to round.
- 0.1 is the specified number of digits.
Therefore, ROUND(D5,0.1) rounds the number of cell D5 which is 12.57, and returns the result as 13.
➤ After that, press ENTER.
We can see the result in cell E5.
➤ Then, we will drag down the formula with the Fill Handle tool.
Finally, we can see the price is rounded to 10 cents in the Rounded to 10 Cents column.
Read More: How to Round to Nearest Whole Number in Excel
Download Workbook
Conclusion
Here, we tried to show you 4 methods to change round to nearest 10 cents in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section. Please visit our website Exceldemy to explore more.
Related Articles
- Round to Nearest 5 or 9 in Excel
- How to Round Down to Nearest Whole Number in Excel
- How to Round Numbers to the Nearest Multiple of 5 in Excel
- Excel VBA: Round to Nearest 5
- Round Down to Nearest 10 in Excel
- How to Round to Nearest 100 in Excel
- How to Round Numbers to Nearest 10000 in Excel
- How to Round to Nearest 1000 in Excel
- How to Roundup a Formula Result in Excel
<< Go Back to Rounding in Excel | Number Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
