# Excel Round to 2 Decimal Places (with Calculator)

For different purposes you may need to present a number rounded up to 2 decimal places. Our agenda for today is to show you several ways to round numbers to 2 decimal places. For conducting the session, we are using Excel 2019. You can use your preferred one.

Before diving into the big picture, let’s get to know about today’s workbook. In this workbook we have a basic table for students and their scoring out of 1000. Using this table we will see how to round numbers to 2 decimal places.

To keep it simple we have brought this table to you, where Average score is in decimal values. In a real scenario, not all time averages will be fraction values and at the same time your data sets may have other fraction values.

## Practice Workbook

You are welcome to download the practice workbook from the link below

## 1. Round Numbers to 2 Decimal Places using Excel Format Feature

### 1.1. Number Formatting

Excel provides a format feature, using that you can round values easily.

On the Home tab you will find the Number section. From there you can format your values.

For the purpose of comparing the original and rounded values we have copied the original values (Average column) to another column. Now select any of the values and explore the Number section for that one. For a number having more than 2 decimal places (unless you have something predefined) you should see it’s in the format of the General category.

Now, Click on the list icon next to the category name. You will find a number of categories. Select the category called Number. The value will be rounded to 2 decimal places and the format will be changed to Number from General.

Let’s try another way of rounding up to 2 decimal points.

Explore the Number section again. You will find the Decrease Decimal option. Click that for the number of times you need to reach 2 decimal places. In this example, we clicked a couple of times since we had 4 decimal places. ### 1.2. Custom Formatting

Excel provides you the option to choose your customized format.

Explore the Number section and Click the list icon next to the category. You will find a number of options (did it earlier also).

At the bottom you will find an option called More Number Formats. Click More number Formats, it will pop up a dialog box in front of you. Now in this dialog box you will find an option called Custom. Selecting that option, you can insert your suitable format on the Type box, though Excel has some predefined format created evaluating several case studies. We have selected 0.00 since we need numbers up to 2 decimal places. Then hit Enter or click OK We have got the number to 2 decimal places successfully.

You can choose your own way to insert formats. Let’s roll back a bit and for this 688.6667 value again go to the format box. We have inserted “#.##” as format. Then clicking OK (or by Hitting Enter) we have got something like the image below Now you choose the format you have inserted.

Selecting the cell, you want to format, go to the format dialog box again Usually, your inserted formula will be at the bottom of the format type. So Scroll Down and select the format. It worked perfectly. Similar to this you can form your format for any type of input in Excel.

Now you can use any of the Number Formatting techniques or Custom Formatting techniques for the rest of the values in the example sheet. ## 2. Round 2 Decimal Places Numbers using Formula

### 2.1. Round using ROUND function

For rounding a number you can use a function called ROUND.

The syntax for this function is

`ROUND(number, num_digits)`

number: The number you want to round

num_digits: The number of digits to which number should be rounded

You can know more about the ROUND function by exploring Microsoft Support site.

Since our agenda is to round numbers by 2 decimal places so in the following examples, we will use 2 in the placeholder for num_digits. We have written the ROUND function for the average score of Jesmin. And from a number of 4 decimal places it provided a number to 2 decimal places.

If you notice, you will see in the Average column the number was 748.6667, but in the Rounded Average column the value is 748.67.

Hope you can remember, whenever the leaving digit is going to be more or equal 5, 1 is added to the right most remaining digit. ROUND function adapts the same method.

Let’s write the function for the next value. Here, the earlier value was 749.3333. When we wrote the ROUND function for converting the number to the format of 2 decimal places, it gave 749.33, as the last leaving digit was 3 (less than 5).

Now for the rest of the values, write the function or you can exercise the Excel Autofill feature.

Since it’s time to practice, better write the function. ### 2.2. Round using ROUNDUP function

Similar to the ROUND function you can use the ROUNDUP function.

For syntax you will not find any dissimilarities between ROUND and ROUNDUP

`ROUNDUP(number, num_digits)`

number: The number you want to round up

num_digits: The number of digits to which number should be rounded up

You can know more about ROUNDUP function exploring Microsoft Support site.

Write the function in Excel. You might wonder why you should use ROUNDUP instead of ROUND, since the syntax is the same and the result is the same as well!

The ROUNDUP function returns numbers in its upper limit or ceiling closest to the original number.

Here our number was 748.6667 and our aim was to get up to 2 decimal places.

Writing the formula, we have got 748.67 which is higher than the original 748.6667

Let’s observe another value here. Using ROUNDUP for the 749.3333 we have got 749.34.

Do the same for the rest of the values. ### 2.3. Round 2 Decimal Places using ROUNDDOWN function

Rounding a number can be done by the ROUNDDOWN function. The name says the whole story, this function will return the number towards the closest value in downwards direction.

Syntax is still same as ROUND or ROUNDUP

` ``ROUNDDOWN(number, num_digits)`

number: The number you want to round down

num_digits: The number of digits to which number should be rounded down

You can know more about ROUNDDOWN function exploring Microsoft Support site.

Write the function in Excel. You will find the number like this. It will return numbers in such a way that the decimal values are closer to 0.

Where for the ROUND function, 2 decimal places format value of 748.6667 was 748.67, for ROUNDDOWN function it’s 748.66

Write the functions for the rest of the values for better understanding. ### 2.4. TRUNC Function

One function that may come to your mind is TRUNC.

The syntax for TRUNC is also similar to the ROUND.

`TRUNC(number, num_digits)`

number: The number you want to truncate

num_digits: The precision of the truncation.

You can know more about the TRUNC function exploring Microsoft Support site.

The num_digits parameter for TRUNC function is optional. If you don’t provide it, it will be 0 by default. The TRUNC function also aims to provide decimal place values close to 0. This function will provide you a value that is lesser to the original value. Do the same for the rest of the values. ## Conclusion

That’s all for the session. We have tried listing out several ways to round numbers to 2 decimal places. Hope that will help you. Feel free to comment if anything seems difficult to understand. Let us know which of the methods you have liked most and are going to use.

You can also let us know your way of rounding numbers to 2 decimal places.

## Calculator

You can use today’s practice workbook as a calculator to count round numbers.

You will find a sheet called Calculator. Explore the sheet. We have set the calculator in such a way, so that you can choose your desired number of decimal places.

Select the method you want to use from the drop down Choose Method section. Then Insert your number and preferred decimal places. It will provide you with the result.

One example has been done for you.  