Round to 2 Decimal Places in Excel and Google Sheets
Purpose
Rounding to 2 decimal places is one of the most common operations in any financial spreadsheet, and the single most…
Rounding to 2 decimal places is one of the most common operations in any financial spreadsheet, and the single most important thing to understand is that formatting a cell to show 2 decimal places is not the same as rounding it. Formatting changes how a number looks. ROUND changes what it actually is. When a formatted but unrounded number flows into a SUM or a calculation, it uses its full stored precision and you get totals that do not match what is displayed -- the classic penny-discrepancy problem that turns up in invoices and financial reports. ROUND, ROUNDUP, and ROUNDDOWN are the three functions that actually change the stored value. ROUND uses standard mathematical rounding. ROUNDUP always rounds away from zero. ROUNDDOWN always rounds toward zero. Knowing when to use each one -- and always using one of them rather than relying on cell formatting -- is what keeps financial spreadsheets accurate and auditable.
Syntax
✓ Excel 2003+
✓ Google Sheets
= Same syntax
=ROUND(number, 2)
Variants: ROUNDUP(number,2) always rounds up. ROUNDDOWN(number,2) always rounds down.
Arguments
| Argument | Required | Description |
|---|---|---|
| number | Required | The value to round. Can be a cell reference, a formula result, or a literal number. |
| num_digits | Required | The number of decimal places to round to. Use 2 for two decimal places. Use 0 to round to the nearest whole number. Use negative values to round to tens, hundreds, or thousands. |
How it works
ROUND evaluates the number argument and rounds it to the specified number of decimal places using standard half-up rounding: if the digit immediately after the last kept decimal place is 5 or higher, the last kept digit rounds up; if it is 4 or lower, it stays the same. The result is stored as the rounded value, not just displayed that way. ROUNDUP works identically except it always rounds away from zero regardless of the following digit -- even 12.341 becomes 12.35 with ROUNDUP(x,2). ROUNDDOWN always truncates toward zero -- 12.349 becomes 12.34. For currency work, ROUND(value,2) is the correct default. ROUNDUP is used when a fractional penny must always become a full penny (common in tax and VAT calculations). ROUNDDOWN is used when a partial unit should never be counted as a full unit. Negative num_digits rounds to the left of the decimal: ROUND(1567,-2) returns 1600.
Examples
1
Round a column of calculated unit prices to exactly 2 decimal places for invoice display.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Raw Price | Rounded |
| 2 | Wireless Mouse | 12.347 | =ROUND(B2,2) |
| 3 | USB Cable | 7.891 | 7.89 |
| 4 | Laptop Stand | 34.505 | 34.51 |
| 5 | Webcam | 29.994 | 29.99 |
| 6 | Keyboard | 45.125 | 45.13 |
| 7 | Monitor | 189.999 | 190.00 |
Row 2: 12.35
— 12.347 has a third decimal of 7 which is 5 or above, so the second decimal rounds up from 4 to 5, giving 12.35. Laptop Stand at 34.505 rounds up to 34.51 because the third decimal is 5.
ROUND changes the stored value to 12.35, not just the display. If B2 is formatted to show 2 decimal places without ROUND, it still stores 12.347 and any formula referencing it uses that full value.
2
Use ROUNDUP to ensure every partial penny always rounds up -- useful for tax-inclusive price calculations where undercounting is not acceptable.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Raw Price | Rounded Up |
| 2 | Item A | 14.521 | =ROUNDUP(B2,2) |
| 3 | Item B | 8.007 | 8.01 |
| 4 | Item C | 22.341 | 22.35 |
| 5 | Item D | 5.000 | 5.00 |
| 6 | Item E | 9.991 | 9.99 |
Row 2: 14.53
— 14.521 has a third decimal of 1 -- standard ROUND would leave the second decimal as 2 giving 14.52. ROUNDUP ignores the rounding digit and always rounds up, giving 14.53.
Item E at 9.991 rounds up to 9.99 not 10.00 because the second decimal is already 9 and the third is 1 -- ROUNDUP only moves to the next value if there is anything beyond the kept decimal places, which there is (0.001).
3
Use ROUNDDOWN to truncate to 2 decimal places, always dropping any third-decimal remainder -- useful for calculating minimum discount amounts.
| A | B | C | |
|---|---|---|---|
| 1 | Discount | Raw Amount | Rounded Down |
| 2 | 10% off 199.99 | 19.999 | =ROUNDDOWN(B2,2) |
| 3 | 5% off 111.20 | 5.560 | 5.56 |
| 4 | 15% off 149.95 | 22.4925 | 22.49 |
| 5 | 20% off 89.99 | 17.998 | 17.99 |
| 6 | 8% off 67.50 | 5.400 | 5.40 |
Row 2: 19.99
— 19.999 would round up to 20.00 with ROUND. ROUNDDOWN truncates toward zero at the second decimal place, giving 19.99 -- the customer never receives more than the strict calculated discount.
ROUNDDOWN toward zero means positive numbers always decrease and negative numbers always increase (become less negative). For discount and deduction calculations, ROUNDDOWN is the conservative choice that never overstates the reduction.
Common use cases
1. Round unit prices in an invoice to 2 decimal places so totals match displayed values
=ROUND(B2,2)
2. Round tax amounts up to the nearest penny to avoid underpayment
=ROUNDUP(B2*0.2,2)
3. Round discount amounts down so customers never receive more than the stated discount
=ROUNDDOWN(B2*C2,2)
4. Round a calculated percentage to 2 decimal places for display in a KPI dashboard
=ROUND(B2/C2*100,2)
5. Round a large financial figure to the nearest hundred using a negative num_digits
=ROUND(B2,-2)
Common errors
Totals do not match displayed values
Numbers are formatted to 2 decimal places but not actually rounded. SUM uses the full-precision stored values, creating totals that differ from the sum of displayed numbers.
Fix: Apply ROUND to every value before summing: =SUM(ROUND(B2,2),ROUND(B3,2)) or round individual source values with ROUND before they feed into a SUM column.
ROUNDUP gives an unexpectedly higher value
ROUNDUP rounds away from zero even when the dropped digit is 1 or 2, which surprises users expecting standard rounding behaviour.
Fix: Use ROUND for standard half-up rounding. Only use ROUNDUP when the requirement is always round up regardless of the next digit.
#VALUE! error
The number argument contains text rather than a number -- often from a formula that returns text in certain conditions.
Fix: Check that the input cell is numeric with ISNUMBER. Wrap in VALUE if the number is stored as text: =ROUND(VALUE(B2),2).
Tips and variations
Always ROUND values that feed into financial calculations
Format alone does not change the stored value. Any cell that contributes to a SUM, multiplication, or other calculation should be rounded with ROUND before it is referenced. This eliminates the penny-discrepancy problem permanently.
=ROUND(B2*C2,2)
Use ROUND with 0 for whole-number rounding
=ROUND(B2,0) rounds to the nearest integer. Combined with INT for always-floor and CEILING for always-ceiling, these three cover every whole-number rounding requirement.
=ROUND(B2,0)
Combine ROUND with percentage calculations to display clean results
Percentage calculations often produce long decimals. Wrapping the result in ROUND gives a display-ready value: =ROUND(B2/C2*100,2) shows a percentage to 2 decimal places as a clean number rather than a long floating-point string.
=ROUND(B2/C2*100,2)
Excel vs Google Sheets
Frequently asked questions
Use =ROUND(A2,2) where A2 is the number you want to round and 2 is the number of decimal places. ROUND follows standard rounding rules: digits 5 and above round up, digits 4 and below round down. For example, =ROUND(12.347,2) returns 12.35 and =ROUND(12.344,2) returns 12.34. The same formula works in Google Sheets.
ROUND rounds to the nearest value using standard mathematical rounding -- 5 and above goes up, 4 and below stays down. ROUNDUP always rounds away from zero regardless of the digit, so =ROUNDUP(12.341,2) returns 12.35 not 12.34. ROUNDDOWN always rounds toward zero, so =ROUNDDOWN(12.349,2) returns 12.34 not 12.35. Use ROUNDUP when you must never understate a value, and ROUNDDOWN when you must never overstate one.
No. Formatting only changes how the number is displayed -- the underlying stored value remains the full precision original. =ROUND(A2,2) actually changes the stored value to 2 decimal places. If a formula elsewhere references a formatted but unrounded cell, it uses the full-precision value. Always use ROUND when the rounded value itself needs to be used in further calculations.
Use =ROUND(A2,2) for standard rounding to the nearest penny. For financial contexts where you always round up (to avoid under-charging), use =ROUNDUP(A2,2). For contexts where you always round down (to avoid over-charging), use =ROUNDDOWN(A2,2). Most accounting systems use standard ROUND to 2 decimal places for currency calculations.
Yes. A negative num_digits argument rounds to the left of the decimal point. =ROUND(1234,-2) rounds to the nearest 100 and returns 1200. =ROUND(1234,-1) rounds to the nearest 10 and returns 1230. This is useful for rounding large figures to thousands or hundreds in financial summaries.