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
- 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.
- [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
- 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.
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
- 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.
- 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)