Excel ROUND Function

ROUND changes a number to a fixed number of decimal places and returns the rounded result. Unlike changing a cell's number format, ROUND alters the value Excel actually stores, so any formula that references that cell uses the rounded number, not the original. The part beginners miss most: a negative number of decimal places rounds to the left of the decimal point, into the tens, hundreds, or thousands.

Available in: Excel 365, Excel 2021, Excel 2019, Excel 2016, and all earlier versions, including Excel for the web and Excel for Mac. ROUND has no version restrictions.

Syntax

=ROUND(number, num_digits)

Parameter	Required	Description
`number`	Yes	The number you want to round. Can be a value, a cell reference, or the result of another formula like a SUM or an average.
`num_digits`	Yes	How many decimal places to round to. Use a positive number to round right of the decimal point, `0` to round to the nearest whole number, or a negative number to round left of the decimal point.

ℹ

"Rounding" means adjusting a number up or down to a simpler value. ROUND doesn't truncate or cut off digits; it looks at the digit right after your rounding point to decide whether to round up or down.

Basic Example

You're building a commission tracker and need to round a calculated payout to the nearest cent before it goes on a check.

=ROUND(B2, 2)

// B2 = 2384.567, the raw commission amount
// 2  = round to 2 decimal places

Excel looks at the third decimal digit (7) to decide the rounding direction, then returns 2384.57. That's now the actual value in the cell. If you reference this cell in another formula, Excel uses 2384.57, not the original 2384.567.

How ROUND Works

Positive num_digits rounds right of the decimal point

Use a positive number to keep a specific number of decimal places. =ROUND(19.995, 2) returns 20, because rounding to 2 decimals pushes the third decimal (5) up and carries into the whole number.

Zero rounds to the nearest whole number

=ROUND(4.5, 0) returns 5. This is the most common setting when you want a clean integer without any decimal remainder, and it's functionally the same as omitting decimals entirely.

Negative num_digits rounds left of the decimal point

This is the one that trips people up. =ROUND(2384, -2) returns 2400, rounding to the nearest hundred. =ROUND(2384, -3) returns 2000, rounding to the nearest thousand. Each step further negative moves the rounding point one place further left.

ROUND rounds half away from zero

When the digit being dropped is exactly 5, ROUND rounds away from zero rather than to the nearest even number (a method sometimes called "banker's rounding"). =ROUND(2.5, 0) returns 3, and =ROUND(-2.5, 0) returns -3. Some other tools default to rounding 2.5 down to 2; Excel does not.

ROUND changes the stored value, not just the display

This is the biggest difference between ROUND and formatting a cell to show fewer decimals. Increasing or decreasing decimals from the Home tab only changes what's displayed. The cell still holds the full, unrounded number underneath, and every formula that references it uses that original number. ROUND is different: it produces a new value, and that new value is what gets stored and referenced going forward.

Common Use Cases

Round an invoice total to whole cents

You've calculated a subtotal with tax that lands on an awkward decimal like $148.6666.

=ROUND(D2, 2)   // returns 148.67

Round large numbers to the nearest 10, 100, or 1,000

You're summarizing sales figures for an executive report and don't need exact dollars down to the cent.

=ROUND(F2, -2)   // rounds to the nearest hundred

// F2 = 48,732
// -2 = round two places left of the decimal (hundreds)
// returns 48,700

For rounding to a specific increment other than a power of 10, like nearest 5 or nearest 25, use MROUND instead. ROUND only rounds to place values (tens, hundreds, thousands), not arbitrary multiples.

Round prices to end in .99

You're pricing products and want every listed price to end in .99 instead of a round dollar amount.

=ROUND(G2, 0) - 0.01

// G2  = 19.45, the calculated cost-plus-margin price
// first rounds to the nearest whole dollar (19)
// then subtracts 0.01 to land on 18.99

Round inside a larger calculation

You want to round the result of an average before it feeds into another formula, rather than rounding after the fact.

=ROUND(AVERAGE(scores), 1)

// scores  = a named range of test results
// 1       = round the average to one decimal place

Handling Errors

ROUND is a stable function and rarely fails, but it can throw #VALUE! when it can't interpret one of its arguments as a number.

Common causes of #VALUE!:

number points to a cell containing text instead of a numeric value
num_digits is text or a non-numeric reference
One of the arguments references a cell that itself contains an error

=IFERROR(ROUND(A2, 2), "Check input")

✓

If a column of "numbers" won't round and keeps throwing #VALUE!, check whether the values are actually text. Numbers imported from other systems or CSV files often look numeric but are stored as text, and ROUND can't process them until you convert them (multiply by 1, or use VALUE()).

Notes & Gotchas

How do you round numbers in Excel?

Use the ROUND function: =ROUND(number, num_digits). Set num_digits to 0 for a whole number, a positive number for decimal places, or a negative number to round to tens, hundreds, or thousands.

What is the formula for rounding in Excel?

The formula is =ROUND(number, num_digits), where number is the value or cell you want to round and num_digits controls precision. For a value in cell A2 rounded to 2 decimal places, that's =ROUND(A2, 2).

What's the difference between ROUND, ROUNDUP, and ROUNDDOWN?

ROUND rounds to the nearest value based on standard rounding rules. ROUNDUP always rounds away from zero regardless of the digit that follows, and ROUNDDOWN always rounds toward zero. All three share the same syntax, so switching between them only means changing the function name.

How do you round to the nearest 10, 100, or 1000 in Excel?

Use ROUND with a negative num_digits: -1 rounds to the nearest 10, -2 to the nearest 100, and -3 to the nearest 1,000. =ROUND(4568, -3) returns 5000. If you need a multiple that isn't a power of 10, like nearest 5 or nearest 250, use MROUND instead.

How do you round to 2 decimal places in Excel?

Set num_digits to 2: =ROUND(A2, 2). This is the standard formula for rounding currency values to the cent.

Does formatting cells round the actual value the same way ROUND does?

No, and this is the mistake that causes the most confusion. Increasing or decreasing decimal places from the ribbon changes only what's displayed in the cell; the full, unrounded value is still stored underneath and is what any formula referencing that cell will use. ROUND is different: it creates an actual rounded value that other formulas will see and use.

⚠

A cell showing 12.57 might actually contain 12.5749 if you only changed the display format. Sum a column of cells that "look" rounded via formatting and you can get a total that doesn't match what you'd expect from adding the displayed numbers. Use ROUND, not formatting, whenever downstream formulas depend on the rounded result.

Does ROUND round 0.5 up or down?

ROUND always rounds a trailing 5 away from zero, not to the nearest even number. =ROUND(1.5, 0) returns 2, and =ROUND(2.5, 0) also returns 3, not 2. This differs from "round half to even" logic used in some statistical software.

What happens if num_digits is larger than the number of decimals already in the number?

Nothing changes. =ROUND(4.5, 4) still returns 4.5, since there's nothing to round at the fourth decimal place. ROUND never adds trailing zeros to the stored value; it only removes precision, never adds fake precision.

Related Functions

Function	Use this when...