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.

**Table of Contents**hide

## Download Workbook

## 4 Methods to Round to Nearest 10 Cents in Excel

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:** **Round to Nearest 5 or 9 in Excel (8 Easy Methods)**

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

**Read More:** **Round off Formula in Excel Invoice (9 Quick Methods)**

**Similar Readings**

**How to Round a Formula with SUM in Excel (4 Simple Ways)****Rounding Time to Nearest Quarter Hour in Excel (6 Easy Methods)****How to Remove Decimals in Excel with Rounding (10 Easy Methods)****Rounding Time in Excel to Nearest Hour (6 Easy Methods)****How to Add ROUND Formula to Multiple Cells in Excel (2 Easy Ways)**

### 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 (6 Easy Ways)**

### 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: ****Round Time to Nearest 5 Minutes in Excel (4 Quick Methods)**

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