# 5 Ways to Round Up a Formula Result in Excel

One common task in Excel is to perform calculations with formulas. These formulas do not return the rounded-up results automatically. Sometimes you may want to round up the result of a formula to make it more readable or to comply with specific requirements. In this article, I will introduce you to 5 ways that will help you round up a formula result in Excel.

Whether you are a beginner or an experienced Excel user, this article will help you learn how to round up formula results in Excel and improve your data analysis skills.

### Introduction to the Dataset

In the following scenario, the total prices are calculated with an easy formula shown in the **Formula Bar**. Notice, all the total prices exhibit **2 decimal places**. But to make it easy to understand, I want to round up the formula results shown in the column, **Total Price. **So, let’s begin.

## Easiest Way to Round Up a Formula Result in Excel

First, I am going to use the **ROUNDUP function**. Because it is assigned for rounding up numbers with any type of decimal place.

**Syntax**

=ROUNDUP([formula], [number of digits])

**Formula**

**=ROUNDUP((B2*C2),0)**

**Usage Guide**

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

**Step_2**: Hit **ENTER**.

**Step_3**: Now place the cursor on the right-bottom corner of **cell D2**.

The **Fill Handle (+) **icon will show up.

**Step_4**: Double-click on the **Fill Handle** icon to apply the formula and round up the formula results.

**Final Result >**

The formula results in the cell range **D2:D12** are now all rounded up. I find the **ROUNDUP function** the most straightforward way to round up a formula result in Excel.

**Formula Explanation**

: The formula that is already used in**Formula****cell D2**. The formula that I have in**cell D2**is**B2*C2**.: It is the number of digits that you want after the decimal point.**Number of digits**

**[3 Ways] Round Off Time to Nearest Multiple of 5 Minutes in Excel****2 Ways to Round to Nearest 50 Cents in Excel**

### Alternative Way #1: Use the CEILING Function to Round Up a Formula Result in Excel

The **CEILING function** is similar to the **ROUNDUP function**. But the **CEILING function** always rounds up to the nearest multiple of a given value.

**Syntax**

=CEILING([formula],[significance])

**Formula**

=CEILING((B2*C2),1)

**Usage Guide**

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

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

**Step_3**: Move the cursor to the lower-right corner of **cell D2**. The **Fill Handle (+)** icon will appear.

**Step_4**: Double-click the **Fill Handle** icon to copy down the formula and round the formula results up.

**Final Result >**

The **CEILING function** perfectly performed the same job as the **ROUNDUP function**.

**Formula Explanation**

: It represents the formula that you need to round up. The formula that I use is**Formula****B2*C2**.: The number to whose multiple you want to round up your number.**Significance**

### Alternative Way #2: Use the MROUND Function to Round Up a Formula Result in Excel

The **MROUND function** is similar to the **CEILING function**. But the **MROUND function** is used for rounding up or down to a multiple of a specified number.

**Syntax**

=MROUND([formula],multiple)

**Formula**

=MROUND((B2*C2),1)

**Usage Guide**

**Step_1**: First, write the formula in **cell D2**.

**Step_2**: Then press the **ENTER** key.

**Step_3**: Then place the cursor on the right-bottom corner of **cell D2**.

It will show up as the **Fill Handle (+)** icon.

**Step_4**: Double-click on the **Fill Handle** button to apply the formula and round up the formula results.

**Final Result >**

The **MROUND function** works fine to round up the formula results in Excel.

**Formula Explanation**

: The formula that requires rounding up in**Formula****cell D2**. In my dataset, I have**B2*C2**inside**cell D2**.: It is the value to which you want to round up the**Multiple**.*Formula*

**4 Formulas to Round Off Prices To Nearest 10 Cents in Excel****3 Formulas to Round Time to the Nearest Minute in Excel**

### Alternative Way #3: Using Cell Format Dialog Box to Round Up a Formula Result in Excel

You can also round up a formula result by formatting the cell to display a certain number of decimal places. Follow the steps below to do that.

**Usage Guide**

**Step_1**: At first, select the cells from **D2** to **D12**.

**Step_2**: Then right-click on the cell range **D2:D12**.

This will display the **Context Menu** in front of the selected cell range.

**Step_3**: Select the **Format Cells** option from the menu to open the **Format Cells dialog box**.

**Step_4**: Now, under the **Number** tab, select the number format you want from the **Category**.

In my case, the dataset is about the pricing of some grocery items. That’s why I selected **Currency **from the **Category**.

**Step_5**: Now, type **“0”** in the **Decimal places **box to round up the values.

You can specify the number of decimal places to display in the **Decimal places **box. For example, If you type **1**, the formula result of **cell D2** will show **16.2**; if you type **2**, the result of **cell D2** will display **16.23**.

**Final Result >**

You can see Excel has rounded up the formula results to the specified number of decimal places.

### Alternative Way #4: Use the Decrease Decimal Button to Round Up a Formula Result in Excel

You can also use the **Decrease Decimal** buttons on the **Home** tab of the ribbon. This will not change the actual value of the cell, but it will round up the displayed value to the specified number of decimal places.

**Usage Guide**

**Step_1**: At first, select the cells from **D2** to **D12**.

**Step_2**: Now go to the **Home** tab.

**Step_3**: Then click on the **Decrease Decimal** button located on the **Number** group.

**Final Result >**

Using the **Decrease Decimal** button is a very handy way to round up formula results or any sort of value in Excel.

## Conclusion

I discussed 5 very efficient techniques in this article. I hope now you can round up formula results by using any of these methods. Feel free to ask any questions regarding this topic in our comment section below. To read more articles related to rounding up in Excel, **click here**. Thank you!

**Related Articles**

**How to Round Off Numbers in Excel (9 Methods)****3 Formulas for Rounding Time to the Nearest Hour in Excel****[3 Formulas] Round Off Time to Nearest Multiple of 15 Minutes in Excel****5 Ways to Round a Formula with SUM Function in Excel****2 Ways to Stop Excel from Rounding up Percentages****How to Stop Excel from Rounding 16-Digit Numbers (2 Methods)**