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_digits | What it does | Example | Result |
|---|---|---|---|
| 2 | Rounds to 2 decimal places | 125.678 | 125.68 |
| 1 | Rounds to 1 decimal place | 125.678 | 125.7 |
| 0 | Rounds to the nearest whole number | 125.678 | 126 |
| -1 | Rounds to the nearest ten | 126 | 130 |
| -2 | Rounds to the nearest hundred | 1,267 | 1,300 |
| -3 | Rounds to the nearest thousand | 1,267 | 1,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:
| Product | Calculated Price |
|---|---|
| Product A | 125.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:
| Employee | Performance Score |
|---|---|
| Amit | 87.456 |
| Priya | 91.284 |
| Rahul | 76.758 |
| Neha | 89.921 |
Excel Formula:
=ROUND(B2,1)
Copy the formula down for the remaining employees.
Expected Results:
| Employee | Rounded Score |
|---|---|
| Amit | 87.5 |
| Priya | 91.3 |
| Rahul | 76.8 |
| Neha | 89.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:
| Product | Average Daily Quantity |
|---|---|
| Keyboard | 125.7 |
| Mouse | 84.3 |
| Monitor | 36.5 |
Excel Formula:
=ROUND(B2,0)
Expected Results:
| Product | Rounded Quantity |
|---|---|
| Keyboard | 126 |
| Mouse | 84 |
| Monitor | 37 |
Student Task:
Round 248.49 and 248.50 to the nearest whole number.
Expected Results:
248.49→248248.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:
| Employee | Sales (₹) |
|---|---|
| Amit | 12,349 |
| Priya | 18,675 |
| Rahul | 24,421 |
| Neha | 31,850 |
Excel Formula:
=ROUND(B2,-2)
Expected Results:
| Employee | Rounded Sales (₹) |
|---|---|
| Amit | 12,300 |
| Priya | 18,700 |
| Rahul | 24,400 |
| Neha | 31,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:
| Branch | Annual Revenue (₹) |
|---|---|
| Delhi | 1,256,480 |
| Mumbai | 2,784,620 |
| Jaipur | 985,450 |
Excel Formula:
=ROUND(B2,-3)
Expected Results:
| Branch | Rounded Revenue (₹) |
|---|---|
| Delhi | 1,256,000 |
| Mumbai | 2,785,000 |
| Jaipur | 985,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:
| Employee | Target (₹) | Actual Sales (₹) |
|---|---|---|
| Amit | 100,000 | 87,456 |
| Priya | 150,000 | 132,789 |
| Rahul | 200,000 | 184,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:
| Employee | Achievement |
|---|---|
| Amit | 87.46% |
| Priya | 88.53% |
| Rahul | 92.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:
| Product | Amount Before GST (₹) |
|---|---|
| Keyboard | 1,249.99 |
| Mouse | 599.50 |
| Headphones | 1,875.75 |
Excel Formula:
=ROUND(B2*18%,2)
Expected Results:
| Product | Amount Before GST (₹) | GST at 18% (₹) |
|---|---|---|
| Keyboard | 1,249.99 | 225.00 |
| Mouse | 599.50 | 107.91 |
| Headphones | 1,875.75 | 337.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:
| Employee | Annual Sales (₹) |
|---|---|
| Amit | 456,789 |
| Priya | 678,945 |
| Rahul | 589,456 |
Excel Formula:
=ROUND(B2*7.5%,2)
Expected Results:
| Employee | Bonus (₹) |
|---|---|
| Amit | 34,259.18 |
| Priya | 50,920.88 |
| Rahul | 44,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:
| Product | Calculated Unit Cost (₹) | Quantity |
|---|---|---|
| Product A | 125.678 | 50 |
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:
- The rounded unit cost.
- The total using the rounded unit cost.
- 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:
| Branch | Revenue (₹) |
|---|---|
| Delhi | 1,246,000 |
| Mumbai | 2,785,000 |
| Jaipur | 986,000 |
Excel Formula:
=ROUND(B2,-4)
Expected Results:
| Branch | Rounded Revenue (₹) |
|---|---|
| Delhi | 1,250,000 |
| Mumbai | 2,790,000 |
| Jaipur | 990,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:
| Product | Amount Before GST (₹) | GST Rate | Bonus Rate |
|---|---|---|---|
| Keyboard | 1,249.99 | 18% | 5% |
| Mouse | 599.50 | 18% | 5% |
| Monitor | 8,499.75 | 18% | 7.5% |
| Printer | 5,750.25 | 18% | 6% |
| Webcam | 1,199.95 | 18% | 5% |
Your Tasks
- Calculate GST for each product, rounded to two decimal places.
- Calculate the bonus for each product, rounded to two decimal places.
- Calculate the total of the rounded GST amounts.
- Calculate the average product amount, rounded to two decimal places.
- 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_digitsvalues round digits after the decimal point. - A
num_digitsvalue of zero rounds to the nearest whole number. - Negative
num_digitsvalues 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.

