How to Use ROUND in Excel
Rounds a number to a fixed number of decimal places — essential for invoices, GST calculations and currency reports.
What is ROUND in Microsoft Excel?
ROUND changes the stored value, not just how it looks. That matters in finance: a cell formatted to two decimals still holds the full value, but ROUND(…,2) actually stores two decimals so totals reconcile. Use ROUNDUP or ROUNDDOWN when direction must be guaranteed.
Formula Syntax
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| number | Required | The value to round. Can be a cell reference or a calculation. |
| num_digits | Required | How many decimal places to keep. 0 rounds to a whole number, negative values round to tens, hundreds or thousands. |
When to Use ROUND (Real-World Business Scenarios)
- 1
Rounding invoice totals, GST amounts and per-unit prices to two decimals.
- 2
Rounding large numbers to thousands with a negative digit count: =ROUND(A2,-3).
- 3
Preventing floating-point drift in reconciliation sheets where 0.0000001 differences break a check.
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Item | Raw Amount | Rounded |
|---|---|---|
| GST 18% | 1234.5678 | 1234.57 |
| Discount | 99.994 | 99.99 |
| Bulk rate | 45678.9 | 46000 |
How it works: Keeps two decimal places and rounds the third digit up, turning 1234.5678 into 1234.57. The stored value really changes, so later sums match the invoice.
Common Errors & How to Fix Them
Why it happens: Some rows were rounded with ROUND and others only formatted, so the underlying values differ.
Fix: Apply ROUND to every row in the calculation chain, including subtotals, and avoid formatting-only fixes.
Why it happens: num_digits was passed as text, such as "2" copied from another system with quotes.
Fix: Pass a real number: =ROUND(B2,2). If the digit count comes from a cell, convert it with VALUE first.
Try ROUND Live in Your Browser
No need to launch desktop Excel. Practice formulas with real-time feedback in our HyperFormula sandbox.
Frequently Asked Questions (ROUND)
What does the ROUND formula do in Excel?
ROUND changes the stored value, not just how it looks. That matters in finance: a cell formatted to two decimals still holds the full value, but ROUND(…,2) actually stores two decimals so totals reconcile. Use ROUNDUP or ROUNDDOWN when direction must be guaranteed.
What is the syntax for ROUND?
What are common mistakes when using ROUND?
Totals still do not reconcile: Some rows were rounded with ROUND and others only formatted, so the underlying values differ. (Apply ROUND to every row in the calculation chain, including subtotals, and avoid formatting-only fixes.) #VALUE!: num_digits was passed as text, such as "2" copied from another system with quotes. (Pass a real number: =ROUND(B2,2). If the digit count comes from a cell, convert it with VALUE first.)
Related Excel Formulas
Keep building your formula toolkit with these math & stats functions.
- SUMIFSSums numerical values across multiple conditions (e.g. Sales in North Region for Q1).
- COUNTIFSCounts the number of rows that satisfy multiple simultaneous criteria.
- SUMAdds numbers across cells, ranges and entire columns — the first formula most people ever type in Excel.
- SUMIFAdds only the numbers that match one condition — the fastest way to total a region, product or status without a Pivot Table.
- COUNTIFCounts how many cells match a condition — duplicates, blanks, specific text, or values above a limit.
- AVERAGEReturns the arithmetic mean of a range while automatically ignoring blanks and text.
Master ROUND in Basic Excel
Learn ROUND along with our formula library, practice files, and verifiable certificates in our complete curriculum.