Skip to content

Excel function · Math

Excel ROUND function

ROUND rounds a number to the digit you choose: 2 for cents, 0 for whole units, -2 for hundreds. Unlike cell formatting it changes the value itself, which keeps totals free of penny differences.

In Turkish Excel: YUVARLA

What it does

The second argument says how many decimal places to keep: =ROUND(1234.567,2) returns 1234.57, =ROUND(1234.567,0) 1235 and =ROUND(1234.567,-2) 1200. Negative values round to the left of the decimal point: to tens, hundreds and thousands.

Halves are rounded away from zero: 2.5 becomes 3 and -2.5 becomes -3. To round only up use ROUNDUP, only down ROUNDDOWN, and to a multiple (5 cents, a quarter of an hour) MROUND.

Reducing decimals with cell formatting only changes the look; the value behind it stays as it was, so a total may not match the numbers you see. For amounts that are calculated row by row and then added, such as VAT, discounts or currency conversion, rounding each row to cents with ROUND gives exactly the same total as the invoice.

Syntax

English Excel=ROUND(number, num_digits)
Turkish Excel=YUVARLA(sayı; basamak)

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription
numberRequiredThe number, cell or formula to round (such as B2*0.2).
num_digitsRequiredThe number of decimal places to keep. 0 rounds to a whole number; negative values round to tens (-1), hundreds (-2) or thousands (-3).

Examples

1Round VAT to cents row by row

Each row's VAT is calculated at 20% and rounded to cents; the gross amount is the net plus the rounded VAT. The totals underneath match the invoice lines exactly.

C2fx=ROUND(B2*0.2,2)
Round VAT to cents row by row: example table
ABCD
1ItemNetVATGross
2Consulting1,249.99250.001,499.99
3Software licence87.3517.47104.82
4Training512.48102.50614.98
5Delivery33.336.6740.00
6Total1,883.15376.642,259.79
  • C2 (filled down to C5)=ROUND(B2*0.2,2)
  • D2 (filled down to D5)=B2+C2
  • B6=SUM(B2:B5)
  • C6=SUM(C2:C5)
  • D6=SUM(D2:D5)

The VAT on 1,249.99 becomes 250.00 rather than 249.998; on the training row it is 102.50. The VAT total is 376.64 and the grand total 2,259.79.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

2Round the same number to different digits

The number in D2 is rounded with each value in column A. Positive values round the decimals; negative values round the digits to the left of the decimal point.

B2fx=ROUND($D$2,A2)
Round the same number to different digits: example table
ABCD
1DigitsResultNumber
221234.571234.567
311234.6
401235
5-11230
6-21200
7-31000
  • B2 (filled down to B7)=ROUND($D$2,A2)

With 2 digits the result is 1234.57, with 0 it is 1235 and with -2 it is 1200. -3 rounds to the nearest thousand: 1000.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

3Which way are halves rounded?

ROUND rounds values exactly halfway away from zero: up for positive numbers, down for negative ones.

B2fx=ROUND(A2,0)
Which way are halves rounded?: example table
AB
1ValueWhole Number
22.53
33.54
4-2.5-3
5-0.5-1
62.492
  • B2 (filled down to B6)=ROUND(A2,0)

2.5 becomes 3 and 3.5 becomes 4; -2.5 becomes -3. 2.49 is below the halfway point, so it becomes 2.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

Common errors and fixes

Penny difference

Cause: The rows were added without rounding, so the sum of the amounts you see differs by a cent or two from the total.

Fix: Wrap each row's calculation in ROUND: =ROUND(B2*0.2,2).

Unexpected whole number

Cause: num_digits was 0 or left empty, so the result was rounded to a whole number.

Fix: Use 2 as num_digits for cents.

#VALUE!

Cause: number or num_digits is text that cannot be read as a number.

Fix: Make sure the cells hold numbers; convert amounts stored as text with VALUE first.

Good to know

  • To round the result of a formula, put the formula inside ROUND: =ROUND(SUM(B2:B9)/3,2).
  • The "Set precision as displayed" option changes the values of the whole workbook permanently; use ROUND where you need it instead.

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Add a VAT column that calculates 20% VAT for each row, rounded to cents

Convert to table

Bring your invoice table into the tool and type this. Nexell adds the VAT column with real Excel formulas and shows it in the preview first; in the downloaded file, the VAT is recalculated when an amount changes.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

What is the difference between ROUND and cell formatting?

Cell formatting only changes the look: 2.675 may show as 2.68, but 2.675 is still used in calculations. ROUND really changes the value, so later calculations use the rounded number.

How do I round to the nearest 5 in Excel?

Use MROUND: =MROUND(A2,5) returns the nearest multiple of 5. To round an amount to 5 cents, use =MROUND(A2,0.05).

How do I round to thousands in Excel?

Use -3 as num_digits: =ROUND(A2,-3). For 1,234,567 the result is 1,235,000.

Related functions

All math functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free