# 2 Ways to Round to Nearest 50 Cents in Excel

Depending on what you want to round and how Excel has a number of distinct **rounding functions**. Depending on the arguments, each of the **rounding functions** assists in rounding a value to a specific number of **decimal places**. In this article, I will describe 4 formulas to round off prices to the nearest 50 cents in Excel.

### Introduction to the Dataset

Here, I have some product names (**Column A**) and their unit prices (**Column B**) in the dataset. Next to these two columns, I have added another column (**Column C**), **Rounded Price**, for presenting the price round to the nearest 50 cents for each product.

## Easiest Way to Round Time to Nearest Minute

Using the **MROUND function** is the easiest and most secure way to round a number to the closest multiple. Note that the **MROUND function** is used to round values to the closest multiple. Sometimes the number is either an integer or a decimal.

**Syntax**

**=MROUND (number, multiple)**

**Formula**

**=MROUND(B2,0.5)**

**Usage Guide**

**Step_1:** First, type the formula in cell **C2**.

**Step_2:** Then press **ENTER**.

**Step_3:** After that copy the formula down to cell **C11** by dragging the right-bottom corner of cell **C2**.

**Final Result**

You can see, all the prices are rounded to the 50-cent price now. Like the value in cell **B2**, **$1.46,** is rounded up and expressed as** $1.50**. But in cell **B5**, the price of Uno Wear is rounded down from **$54.11** to **$54.00 **since it is the nearest rounded value of **$54.11**. If it was rounded upward (**$54.50**), the difference from the main value would have increased have from the main value. Our target is to bring out the nearest values.

**Formula Explanation**

As specified by the syntax of the **MROUND function**, **B2** indicates the * number *in the formula. And

**0.51**is the

**. The**

*multiple**specifies that the formula has to return the nearest multiple of*

**multiple****0.5**of the mentioned number i.e.

**$1.46**.

If you change the ** multiple**,

**0.5**, and mention something else, for example,

**0.2**, the answer will be changed. It will return the nearest multiple of

**0.2**of

**$1.46**.

### Alternative Formula #1: Round to Nearest 50 Cents Using ROUND Function in Excel

Another way to round off prices to their nearest 50 cents is using the **ROUND function** in Excel.

**Syntax**

=ROUND (number, num_digits)

**Formula**

=ROUND(B2*2,0)/2

**Usage Guide**

**Step_1:** At first, type the formula in cell **C2**.

**Step_2:** Press the **ENTER **key.

**Step_3:** Finally, copy the formula down to cell **C8** by dragging the right-bottom corner of cell **C2**.

**Final Result**

The **ROUND function** performed successfully, rounding all **column B** value prices to the nearest 50 cents.

**Formula Explanation**

**B2*2** represents the * number *argument. The

**B2**is multiplied by

**2**to make the value double, which is

**$2.92**. The

**0**is the

*argument. The*

**num_digit****0**indicates that there will be no numbers after the decimal point. So, the values will be either odd or even integers. In my case, the rounded value is

**$3.00**. But since I multiplied cell

**B2**by

**2**at first, that’s why I divided the entire formula by

**2**. So, finally, it returns our answer in cell

**C2**.

## Conclusion

I’ve discussed two methods for rounding off prices to the nearest 50 cents in Excel. This article is meant to be helpful, I hope. Additionally, feel free to post any questions you may have in the comment box below. For more articles like this one on Excel, please visit our **blog** page. Thank you, and have a great day!