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.

Item prices in a dataset of Excel

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.

Use ROUNDUP function to Round up a Formula Result in Excel

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.

Copy down the ROUNDUP function in the cell range to Round up a Formula Result in Excel

Final Result >

Final result of applying the ROUNDUP function to Round up a Formula Result in Excel

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

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


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.

Rounding up a fomula result in Excel with CEILING function

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.

Using Fill Handle button in Excel

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

Final Result >

CEILING function to round up a formula result in Excel

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


Formula Explanation

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

Note: Remember, when using the CEILING function to round up a value, always use “1” as the Significance. As 1 represents the smallest possible value to which the number can be rounded up, we use 1 as the Significance to round up a number to the nearest whole number.

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.

Use the MROUND Function to Round up a Formula Result in Excel

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 >

MROUND function rounded up results in Excel

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


Formula Explanation

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


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.

Using Format Cells otion to open the Cell Format Dialog Box in Excel

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.

Using Cell Format Dialog Box to Round up a Formula Result in Excel

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.

Use the Decrease Decimal Button to Round up a Formula Result in Excel

Note: Hit on the Decrease Decimal button as many times as you want to remove the decimal places. If you want to reappear the decimal places, click on the Increase Decimal button.

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

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *