How to Round Up to 2 Decimal Places in Excel (with Calculator)

Consider a sample dataset where you want to calculate the grade or score average for students.

Method 1 – Using Number Formatting in Excel to Round Up to 2 Decimal Places

To compare the original and rounded values, copy the original values (Average column) to another column named Rounded Average.

Select any of the values and go to the Number section in the Home tab. A number with more than 2 decimal places should be formatted under General.

Go to the Home tab and over to the Number section.
Click on the List icon next to the category name or the drop-down on the format name.
Select Number.

The value will be rounded to 2 decimal places and the format will be changed to Number.

Let’s try another way of rounding up to two decimal places:

Click on the Decrease Decimal. You should have a decimal disappear and the result rounded.
Repeat the process until you’re left with two decimal places.

The value will be rounded to two decimal places and change the format to Number.

You can use any of the Number Formatting techniques for the rest of the values in the example sheet.

Method 2 – Applying Custom Formatting to Round Up to 2 Decimal Places

Select cells from G5:G10.
Press CTRL+1.

A new window named Format Cells will appear.

Go to the Custom option.
Select 0.00 since we need numbers up to two decimal places. You can see the format immediately as Sample.
Hit Enter or click on OK.

All the cells will be reformatted.

Here’s another way to do this:

Select the data.
Go to the Home tab.
Click the List icon next to the Number category.
Click on 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.

So, selecting that option, you can insert your suitable format in the Type box, though Excel has some predefined format created evaluating several case studies.
Inserted “#.##” as a format.
Click on OK (or hit Enter).

After you select a format once, Excel will prompt you with it the next time you choose custom formatting:

Select the cell you want to format and go to the Format Cells dialog box again.
Your inserted formula will be at the bottom of the format type. Scroll down to select the format.

Now, you can use any of the Custom Formatting techniques for the rest of the values in the example sheet.

Method 3 – Using ROUND Function for 2 Decimal Places in Excel

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 the number should be rounded.

Since we’re rounding numbers in Excel to 2 decimal places, in the following examples, we will use 2 in num_digits.

Consider the following ROUND function for the average score of Jasmin (row 5).

Furthermore, 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.

The ROUND function rounds up the number, so if the cut-off digit is 5 or higher, it will increase the last remaining digit.

Use the Excel Autofill Feature to copy the formula throughout the column.

As a result, you will get all the rounded averages up to two decimal places.

Method 4 – Applying ROUNDUP Function to Round Up to 2 Decimal Places

ROUNDUP function’s syntax is the same as ROUND:

ROUNDUP(number, num_digits)

number: The number you want to round up.

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

Steps:

Write this function in the G5 cell.

=ROUNDUP(F5,2)

Press ENTER.

Similarly, by using the ROUNDUP function for the 749.3333, we have got 749.34.

Copy the formula for the rest of the values.

Read More: How to Round up Decimals in Excel

Method 5 – Using ROUNDDOWN Function to Round to 2 Decimal Places

ROUNDDOWN works similarly to ROUND and ROUNDUP, but it rounds the remainder down.

Use the formula in the G5 cell.

=ROUNDDOWN(F5,2)

Press Enter.

While rounding 748.6667 yielded 748.67, the result of the ROUNDDOWN function is 748.66.

Copy the function for the rest of the values.

Method 6 – Inserting TRUNC Function to Round to 2 Decimal Places

TRUNC has a similar syntax to the ROUND functions, but just cuts off the remainder:

In cell G5, type:

=TRUNC(F5,2)

Press ENTER and you’ll have the truncation result.

This function will typically provide you with a value that is lower than the original value.

Copy the formula for other cells through the Fill Handle.

Method 7 – Using Excel VBA to Round to 2 Decimal Places

Steps:

Choose the Developer tab, then select Visual Basic.

In the Insert tab, select Module.

Copy the following Code in the Module:

Sub Rounding_upto_2_decimal()
Dim my_row As Integer
Dim my_work_sheet As Worksheet
Set my_work_sheet = Worksheets("VBA")
For my_row = 5 To 10
my_work_sheet.Cells(my_row, 7).Value = Application.WorksheetFunction.Round(Cells(my_row, 7).Value, 2)
Next my_row
End Sub

Code Breakdown

Here, we have created a Sub Procedure named Rounding_upto_2_decimal. Also, we used the dim statement to define a variable my_work_sheet as Worksheet.
We used the Set statement to set the worksheet named “VBA” using the Worksheets object in my_work_sheet.
We took a variable my_row as an integer and applied a For loop for my_row which will go from the 5th to the 10th row. And 7 is our column number.
We used Round to get the numbers rounded.

Save the code then go back to the sheet.
From the Developer tab, select Macros.

Select Macro (Rounding_upto_2_decimal) and click on Run.

The code will run and populate the rounded average column.

Calculator

You can also use today’s practice workbook as a calculator to count round numbers. Here, you will find a sheet called Calculator.

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

Download Practice Workbook

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

Rounding Up to 2 Decimal Places.xlsm

<< Go Back to Round Up Decimals | Rounding in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!