How to Roundup a Formula Result in Excel (6 Easy Ways)

Rounding up a number to your preferred decimal points allows you to keep your dataset neat and easy to apply the results in real-life situations. Be it employee scheduling, shipping or packaging, counting raw materials, or invoicing, Excel allows you to accurately round a number with the ROUND function.

Overview of Different Rounding Functions in Excel

To use the roundup-related functions perfectly, you must learn how to input the arguments correctly. The common syntax format for the roundup formulas is as follows:

=ROUND(number, num_digits)

Here, the number refers to the decimal number you want to round up. With num_digits, you specify how many numbers you want to keep after the decimal point. Let’s take a look at some examples for better understanding:

• If you set num_digit = 1, it rounds the number to one decimal place.

Example:

=ROUND(542.8778, 1) becomes 542.9

• If you set num_digit = 2, it rounds the number to two decimal places.

Example:

=ROUND(542.8778, 2) becomes 542.88

• If you set num_digit = 3, the number rounds to three decimal places.

Example:

=ROUND(542.8778, 3) becomes 542.878

• If you set num_digit=0, the number rounds to the nearest whole number (integer) and eliminates the fractions completely.

Example:

=ROUND(542.8778, 0) becomes 543

We can also round up the numbers on the left side of the decimal point using negative digits. Here’s how:

• If you set num_digit = -1, the number rounds to the nearest multiple of 10.

Example:

=ROUND(542.8778, -1) becomes 540

• If you set num_digit = -2, the number rounds to the nearest multiple of 100.

Example:

=ROUND(542.8778, -2) becomes 500

• If you set num_digit = -3, the number rounds to the nearest multiple of 1000.

Example:

=ROUND(542.8778, -3) becomes 0 (between 0 and 1000, 542.8778 is closer to 0 than 1000)

Although we used the ROUND function, you can use the same format for any roundup-related format with the num_digit argument.

In our chosen dataset, we’re displaying the different elements of a website. For our roundup methods, we’ll use the Bounce Rate(%) column. We used the SUM function to add the numbers of this column.

While describing the methods, we will use the result of the SUM function to show you how to round the formula result to two places after the decimal point.

With this method, you can change the way a decimal number appears on the worksheet instead of actually changing it permanently. If you use the result in a different formula later, Excel will use the actual value instead of what is displayed on your screen.

So, use it only when you want to protect the original value of a cell while making it look more neat. Here are the steps:

➤ Click on the formula cell and go to the Home tab. Under the Number box, click on the Decrease Decimals sign to reduce decimals from the result.

➤ If you want more customization, click on the arrow sign in the corner to launch the Format Cells dialog box. You can also launch it by pressing  CTRL  +  1 .
➤ On the Number tab, choose the right category according to your data type.
➤ In the Decimal Places box, type the numbers for how many digits of decimal places you want to keep in the result.

➤ Click Ok and Excel will change your data accordingly. Here’s the result for our dataset:

As the function rounds to the nearest number based on the traditional rounding rules, you can use the ROUND function for academic or financial work where you need mathematically accurate results.

It rounds up the last digit for 5 or greater numbers and rounds down for numbers less than 5. Let’s apply it to our dataset.

➤ Select the cell where you want to put the rounded number and type the following formula:

➤ Replace E14 with the cell reference where you want the rounded result. Instead of 2, put the number of places you want to keep after the decimal point.

➤ If you prefer to integrate the ROUND function with the formula in a single cell, follow this format instead:

➤ Replace the Formula part with the correct formula you’ve used, and change the number of places after the decimal point as needed.

➤ You can also put the formula result directly like this:

➤ Finally, press Enter. In all three cases, the result is as follows:

With the ROUNDUP function, you’ll always round a number up, away from zero. No matter how small the decimal part is, it will increase the preceding digit.

On the other hand, the ROUNDDOWN function always rounds a number down, towards zero. No matter how large the decimal part is, it will truncate towards the lower number. Here’s how to use them:

➤ Select a cell to put the rounded result and type any of the following formulas and press Enter:

Or,

➤ Change the values E14 and 2 according to your required cell reference and the number of digits to which you want to round. You can also use the exact formula result or the formula itself instead of E14.

➤ The ROUNDUP function gives a value that is equal to or greater than the original number just like the picture given below:

➤ As for the ROUNDDOWN function, it gives a value that is equal to or less than the original number as shown in the picture below:

To round a number to the nearest even or odd integer while eliminating the fraction part, we use the EVEN and ODD functions in Excel. Whereas the EVEN function rounds the number up to the nearest even integer, the ODD function rounds the number up to the nearest odd integer. Apply these functions using the following steps:

➤ Choose a cell to put the rounded number and type any of the following formulas:

Or,

➤ Replace E14 with your chosen cell reference or the exact formula result you want to round up.

➤ Press Enter and the result for the EVEN function will look like this:

➤ Whereas, for the ODD function, you’ll get results similar to this:

The MROUND function can round a formula result to the nearest multiple of your specified digit. It’s often used to round up currency, time, and other standard measuring units. Here’s how to apply it:

➤ Click on a cell where you want to apply the formula and type the following:

➤ Put your chosen cell value instead of E14. Replace 2 with the multiple to which you want to round the number. You can also apply a formula or its result directly.
➤ Press Enter and you’ll get the converted number rounded to the nearest multiple of your chosen digit.

Frequently Asked Questions

How do I add a round formula to multiple cells in Excel?

First, type the formula in the first cell of the column or row. Press Enter and drag the formula using the tiny black arrow sign in the bottom corner of the cell. Drag it until you cover all the cells you want to apply a round formula and release the cursor when you’re done.

How do you round a formula to a whole number?

To round a formula to a whole number and remove the fractions completely, type the following formula in your preferred cell:

=INT(542.8778)

In this case, the function will return 542. You can replace the number with a formula or cell reference.

Can you round a negative number in Excel?

Yes, you can round a negative number in Excel using functions like ROUNDUP, ROUND, and ROUNDDOWN. Let’s apply the ROUNDUP function for example. Select a cell and type:

=ROUNDUP(-542.8778, 2)

Excel will round up the result to two decimal places, resulting in -542.88.

Wrapping Up

With all the different formulas we’ve covered, you can easily round up a formula result in just a few clicks. Moreover, you can integrate each function with your original formula to skip an extra step. Just make sure you choose the right function among many similar ones and apply the arguments correctly depending on what result you want.