ROUND Function in Excel Tutorial

Excel Tutorial

Introduction

The ROUND function in Excel rounds a number to a specified number of digits. It helps you prepare clean financial reports, calculate rounded prices, display percentages, and simplify decimal values.

For example, you can round ₹125.678 to ₹125.68 or round 1,567 to the nearest hundred. In this tutorial, you will learn ROUND Function in Excel through practical business examples, from basic decimal rounding to salary calculations, percentages, tax reports, and financial analysis.

ROUND Function Syntax

=ROUND(number, num_digits)
  • number: The value or cell reference you want to round.
  • num_digits: The number of digits to which you want to round.
num_digitsWhat it doesExampleResult
2Rounds to 2 decimal places125.678125.68
1Rounds to 1 decimal place125.678125.7
0Rounds to the nearest whole number125.678126
-1Rounds to the nearest ten126130
-2Rounds to the nearest hundred1,2671,300
-3Rounds to the nearest thousand1,2671,000

Important: ROUND changes the calculated value, not just how the number looks. If you only want to change the display, use Excel’s number-formatting options instead.


Question 1: Round a Decimal Number to Two Places

Problem Statement:
An accounts employee calculates a product price with several decimal places. The report requires only two decimal places.

Data:

ProductCalculated Price
Product A125.678

Excel Formula:

=ROUND(B2,2)

Expected Result: 125.68

The formula rounds the value to two digits after the decimal point.

Student Task:
Change the price to 249.4567 and round it to two decimal places.

Expected Formula:

=ROUND(B2,2)

Expected Result: 249.46


Question 2: Round Employee Performance Scores to One Decimal Place

Problem Statement:
A training manager wants to display employee performance scores with one decimal place.

Data:

EmployeePerformance Score
Amit87.456
Priya91.284
Rahul76.758
Neha89.921

Excel Formula:

=ROUND(B2,1)

Copy the formula down for the remaining employees.

Expected Results:

EmployeeRounded Score
Amit87.5
Priya91.3
Rahul76.8
Neha89.9

Student Task:
Add Karan with a score of 82.65. Round the score to one decimal place.

Expected Result: 82.7


Question 3: Round a Number to the Nearest Whole Number

Problem Statement:
A company calculates an average quantity of products sold per day. The report requires a whole number.

Data:

ProductAverage Daily Quantity
Keyboard125.7
Mouse84.3
Monitor36.5

Excel Formula:

=ROUND(B2,0)

Expected Results:

ProductRounded Quantity
Keyboard126
Mouse84
Monitor37

Student Task:
Round 248.49 and 248.50 to the nearest whole number.

Expected Results:

  • 248.49 → 248
  • 248.50 → 249

Question 4: Round Sales to the Nearest Hundred

Problem Statement:
A business report displays sales figures rounded to the nearest hundred rupees for easier reading.

Data:

EmployeeSales (₹)
Amit12,349
Priya18,675
Rahul24,421
Neha31,850

Excel Formula:

=ROUND(B2,-2)

Expected Results:

EmployeeRounded Sales (₹)
Amit12,300
Priya18,700
Rahul24,400
Neha31,900

Student Task:
Round ₹45,650 to the nearest hundred.

Expected Result: ₹45,700


Question 5: Round a Large Number to the Nearest Thousand

Problem Statement:
A company wants to display its annual revenue in a simplified report, rounded to the nearest thousand.

Data:

BranchAnnual Revenue (₹)
Delhi1,256,480
Mumbai2,784,620
Jaipur985,450

Excel Formula:

=ROUND(B2,-3)

Expected Results:

BranchRounded Revenue (₹)
Delhi1,256,000
Mumbai2,785,000
Jaipur985,000

Student Task:
Round ₹3,456,780 to the nearest thousand.

Expected Result: ₹3,457,000

Business Challenge: Why might a company use rounded values in a summary report but retain exact values in its detailed accounting records?


Question 6: Round a Percentage Calculated From Sales

Problem Statement:
A sales manager wants to display each employee’s target achievement as a percentage with two decimal places.

Data:

EmployeeTarget (₹)Actual Sales (₹)
Amit100,00087,456
Priya150,000132,789
Rahul200,000184,567

Assume the target values are in column B and actual sales are in column C.

Excel Formula:

=ROUND(C2/B2*100,2)

Expected Results:

EmployeeAchievement
Amit87.46%
Priya88.53%
Rahul92.28%

The formula returns a percentage number such as 87.46. If you use this exact formula, format the result as a regular number and add the % symbol in the heading. Alternatively, use the following formula and format the result cell as Percentage:

=ROUND(C2/B2,4)

Student Task:
A new employee achieves sales of ₹76,555 against a target of ₹90,000. Calculate the achievement percentage to two decimal places.

Expected Result: 85.06%


Question 7: Round GST Amounts in an Invoice

Problem Statement:
A company sells office supplies and calculates GST at 18%. The accounts team wants each tax amount rounded to two decimal places.

Data:

ProductAmount Before GST (₹)
Keyboard1,249.99
Mouse599.50
Headphones1,875.75

Excel Formula:

=ROUND(B2*18%,2)

Expected Results:

ProductAmount Before GST (₹)GST at 18% (₹)
Keyboard1,249.99225.00
Mouse599.50107.91
Headphones1,875.75337.64

Student Task:
Calculate the GST on a product costing ₹2,499.95 at 18%, rounded to two decimal places.

Expected Formula:

=ROUND(2499.95*18%,2)

Expected Result: ₹450.00

Note: Tax calculation and rounding rules can depend on the applicable invoicing requirements. Follow your organization’s accounting policy.


Question 8: Round a Calculated Employee Bonus

Problem Statement:
A company pays a bonus equal to 7.5% of an employee’s annual sales. The bonus calculation may produce decimal values.

Data:

EmployeeAnnual Sales (₹)
Amit456,789
Priya678,945
Rahul589,456

Excel Formula:

=ROUND(B2*7.5%,2)

Expected Results:

EmployeeBonus (₹)
Amit34,259.18
Priya50,920.88
Rahul44,209.20

Student Task:
Calculate a bonus of 5% on annual sales of ₹725,555, rounded to two decimal places.

Expected Formula:

=ROUND(725555*5%,2)

Expected Result: ₹36,277.75


Question 9: Round a Product’s Unit Cost Before Calculating Total Cost

Problem Statement:
A company imports a product with a calculated unit cost of ₹125.678. The team wants to round the unit cost to two decimal places before calculating the cost of 50 units.

Data:

ProductCalculated Unit Cost (₹)Quantity
Product A125.67850

Step 1: Round the Unit Cost

=ROUND(B2,2)

Expected Result: ₹125.68

Step 2: Calculate Total Cost Using the Rounded Unit Cost

=ROUND(B2,2)*C2

Expected Result: ₹6,284.00

Why this matters: Rounding the unit cost first can produce a different total from multiplying the unrounded cost and rounding only the final amount.

For comparison:

=ROUND(B2*C2,2)

This produces ₹6,283.90.

Student Task:
Use a unit cost of ₹89.456 and a quantity of 120. Calculate:

  1. The rounded unit cost.
  2. The total using the rounded unit cost.
  3. The total by rounding only after multiplication.

Expected Results:

  • Rounded unit cost: ₹89.46
  • Total using rounded unit cost: ₹10,735.20
  • Total rounded after multiplication: ₹10,734.72

Question 10: Round a Number to the Nearest Ten Thousand

Problem Statement:
A company prepares a management report in which large revenue figures are rounded to the nearest ten thousand.

Data:

BranchRevenue (₹)
Delhi1,246,000
Mumbai2,785,000
Jaipur986,000

Excel Formula:

=ROUND(B2,-4)

Expected Results:

BranchRounded Revenue (₹)
Delhi1,250,000
Mumbai2,790,000
Jaipur990,000

Student Task:
Round ₹4,567,890 to the nearest ten thousand.

Expected Result: ₹4,570,000


Student Challenge: Build a Rounded Financial Summary

A company wants to prepare a summary of its product sales, GST, and bonus calculations.

Data:

ProductAmount Before GST (₹)GST RateBonus Rate
Keyboard1,249.9918%5%
Mouse599.5018%5%
Monitor8,499.7518%7.5%
Printer5,750.2518%6%
Webcam1,199.9518%5%

Your Tasks

  1. Calculate GST for each product, rounded to two decimal places.
  2. Calculate the bonus for each product, rounded to two decimal places.
  3. Calculate the total of the rounded GST amounts.
  4. Calculate the average product amount, rounded to two decimal places.
  5. Round the highest product amount to the nearest hundred.

Assume the amount is in column B, GST rate in column C, and bonus rate in column D.

Answer Key

1. GST for each product

In E2:

=ROUND(B2*C2,2)

Copy down.

Expected results:

  • Keyboard: ₹225.00
  • Mouse: ₹107.91
  • Monitor: ₹1,529.96
  • Printer: ₹1,035.05
  • Webcam: ₹215.99

2. Bonus for each product

In F2:

=ROUND(B2*D2,2)

Copy down.

Expected results:

  • Keyboard: ₹62.50
  • Mouse: ₹29.98
  • Monitor: ₹637.48
  • Printer: ₹345.02
  • Webcam: ₹60.00

3. Total rounded GST

=SUM(E2:E6)

Expected result: ₹3,113.91

4. Average product amount

=ROUND(AVERAGE(B2:B6),2)

Expected result: ₹3,459.89

5. Highest product amount rounded to the nearest hundred

=ROUND(MAX(B2:B6),-2)

Expected result: ₹8,500


Key Takeaways

  • ROUND rounds a number to a specified number of digits.
  • Positive num_digits values round digits after the decimal point.
  • A num_digits value of zero rounds to the nearest whole number.
  • Negative num_digits values round to tens, hundreds, thousands, or larger place values.
  • ROUND can be combined with AVERAGE, MAX, and other Excel functions.
  • You can use ROUND in GST, bonus, salary, and sales calculations.
  • Rounding intermediate values can produce different totals from rounding only the final result.
  • Number formatting changes how a value looks, while ROUND changes the calculated value.

Frequently Asked Questions (FAQs)

1. What is the ROUND function in Excel?

The ROUND function rounds a number to a specified number of digits.

2. What is the syntax of ROUND?

The syntax is =ROUND(number, num_digits). The first argument is the value to round, and the second specifies the number of digits.

3. How do I round a number to two decimal places?

Use =ROUND(A1,2).

4. How do I round a number to the nearest whole number?

Use =ROUND(A1,0).

5. How do I round a number to the nearest hundred?

Use =ROUND(A1,-2).

6. What does a negative num_digits value mean?

A negative value rounds to the left of the decimal point. For example, -1 rounds to tens, -2 to hundreds, and -3 to thousands.

7. Does ROUND change the original cell value?

If you enter ROUND in another cell, it returns a rounded result without changing the original cell. The original value changes only if you replace it with the rounded result.

8. What is the difference between ROUND and number formatting?

ROUND changes the calculated result. Number formatting changes only how the value is displayed.

9. Can ROUND be combined with other Excel functions?

Yes. For example, =ROUND(AVERAGE(B2:B10),2) calculates an average and rounds the result to two decimal places.

10. What happens when the digit immediately after the rounding position is 5?

Excel’s ROUND function rounds away from zero at a midpoint. For example, =ROUND(2.5,0) returns 3, while =ROUND(-2.5,0) returns -3.