How to round up number to 2 decimal places in Excel

While using Microsoft Excel sometimes we are having some difficulties with decimal places. If we are using automatic up to 2 decimal places it displays two decimal places but during calculation, it considers all digits after decimal places. If you take printouts and submit invoices to your client they may find wrong calculations in your invoice and reject it.  The intention of this content is to give a clear guideline on round up number to 2 decimal places. Let’s have an example first.

This calculation is made automatically and Grand Total is calculated with the AutoSum function. The Amount column is kept up to 2 decimal places using the ribbon command Decrease decimal.

But if you use your calculator and calculate the summation of the AMOUNT column what would be the result? Let’s check it.

Microsoft Excel says the result is $21.79 but your calculator says that the result is $21.80. There is a difference of $0.01. If your client is so serious about the summation he may reject your invoice to correct and submit it once again.

What is the solution? Is there any solution available in Microsoft Excel? Don’t worry, Excel has a solution to resolve this problem. Today in this content we will guide you to solve this issue.

We will solve this issue using the ROUND function. In addition, we will discuss the ROUNDUP, ROUNDDOWN, and MROUND functions also as these three functions are related to the ROUND function.

What is the ROUND function?

The ROUND function is used to round a number up to desired digits. It works for both decimal places and an integer [Integer means a whole number that does not have any fraction].

In Microsoft Excel, this can be done by the ROUND function very easily. That is what we are talking about from the beginning.

Arguments of the ROUND function

There are only two arguments for the ROUND function. number and num_digits. Let me explain these two arguments first.

number- (required): The number you want to round up.

num_digits (required): At the places you want the number to be rounded. If you do not type any places it considers zero.

Example of the ROUND function

If we dig out the three results above what is the outcome?

1. It is done by normal excel calculation using decreasing decimals to two places which shows the result of $21.79.
2. It is also done by normal excel calculation using increasing decimals to four places which shows the result of $21.7945.
3. It is done by using the ROUND function on all cells which shows the result of $21.80. The used the formula is =ROUND(G4,2)

ROUND function for a Whole number

It is exciting that the ROUND function also works for an integer as well. Syntax and argument are the same as before. Here, we are giving an example for thousands, hundreds and tens. Let’s think about the number 1835.

For Thousands

For Hundreds

For Tens

What is the ROUNDUP function?

As I said earlier, there are three more functions available related to the ROUND function. One of them is ROUNDUP. The ROUNDUP function always rounds a number away from zero.

Arguments for the ROUNDUP function

number (required) – It is any real numbers that you want it to round up.

num_digits (required) -Number of digits which you want the number to be rounded.

Examples

Let’s have some examples to use the ROUNDUP function to be more clear.

Remarks about the ROUNDUP function

• The ROUND function behaves like ROUND unless it always rounds a number up.
• If the num_digits value is greater than the zero value, it is rounded up to the decimal places specified.
• If the num_digits value is less than the zero value, then the number is rounded up to the left of the decimal point.
• If the num_digits value is equal to the zero value, then the number is rounded up to the nearest whole number or integer.

What is the ROUNDDOWN function?

As I said earlier, there are three more functions available related to the ROUND function. One of them is ROUNDDOWN. The ROUNDDOWN function rounds a number down, towards zero.

Arguments for the ROUNDDOWN function

number (required) – It is any real numbers that you want it to round down.

num_digits (required) – Number of digits which you want the number to be rounded.

Examples

Let’s have some examples to use the ROUNDDOWN function to be more clear.

Remarks about the ROUNDUP function

• The ROUNDDOWN function behaves like ROUND unless it always rounds a number down.
• If the num_digits value is greater than the zero value, it is rounded up to the decimal places specified.
• If the num_digits value is less than the zero value, then the number is rounded down to the left of the decimal point.
• If the num_digits value is equal to the zero value, then the number is rounded down to the nearest whole number or integer.

What is the MROUND function?

The MROUND function is an interesting function in Microsoft Excel. It returns a number rounded to the desired multiple. You will be more clear when I discuss with some examples.

Arguments for the MROUND function

number (required) – The value to round.

multiple (required) – The multiple to which you want to round a number.

Examples

Remarks about the MROUND function

• MROUND always rounds up, making it away from zero.

• number and multiple arguments should have the same sign. If not, a #NUM! error is returned.

In this context named How to round up number to 2 decimal places in Excel. I have described all ROUND functions with great examples. I hope you have enjoyed it and this content was really helpful to you. Thanks a lot for being with us.

Content Courtesy: Microsoft Support