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.

Read More: How to Round up Decimals in Excel (4 Simple Ways)

Before diving into the big picture, let’s get to know about today’s workbook.

Workbook - Excel Round to 2 Decimal Places

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.

Rounder average - Excel Round to 2 Decimal Places

Now select any of the values and explore the Number section for that one.

Number Section - Excel Round to 2 Decimal Places

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.

Number - Excel Round to 2 Decimal Places

Select the category called Number.

Number format-Excel Round to 2 Decimal Places

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.

Read More: Excel 2 Decimal Places without Rounding (4 Efficient Ways)

Decrease Decimal - Excel Round to 2 Decimal Places

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.

Example decimal dec -Excel Round to 2 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.

More number - Excel Round to 2 Decimal Places

Click More number Formats, it will pop up a dialog box in front of you.

Dialog box - Excel Round to 2 Decimal Places

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.

Custom - Excel Round to 2 Decimal Places

We have selected 0.00 since we need numbers up to 2 decimal places. Then hit Enter or click OK

Example custom - Excel Round to 2 Decimal Places

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.

Own format -Excel Round to 2 Decimal Places

We have inserted “#.##” as format. Then clicking OK (or by Hitting Enter) we have got something like the image below

Own custom ex-Excel Round to 2 Decimal Places

Now you choose the format you have inserted.

Selecting the cell, you want to format, go to the format dialog box again

Scroll - Excel Round to 2 Decimal Places

Usually, your inserted formula will be at the bottom of the format type. So Scroll Down and select the format.

Custom choice -Excel Round to 2 Decimal Places

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.

All value fill - Excel Round to 2 Decimal Places

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.

ROUND - Excel Round to 2 Decimal Places

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.

ROUND function - Excel Round to 2 Decimal Places

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.

AutoFill-Excel Round to 2 Decimal Places

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.

ROUNDUP

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.

ROUNDUP 2

Using ROUNDUP for the 749.3333 we have got 749.34.

Do the same for the rest of the values.

AutoFill

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.

ROUNDDOWN

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.

AutoFill

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.

TRUNC

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.

AutoFill Trunc

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.

Calculator

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.


Further Readings

Shakil Ahmed

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo