Excel ROUND Function: Formula and Examples

By Dr. Zubair Khalid, DVM, MS, PhD · 2026-10-03

The ROUND function in Excel rounds a number to a specified number of digits. You give it the number and the number of digits you want, and it returns the rounded value. If cell A1 holds 23.7825 and you want two decimal places, the formula is =ROUND(A1,2), which returns 23.78 [1].

Quick Answer

Syntax: =ROUND(number, num_digits) [1].
number is the value you want to round, and num_digits is how many digits to keep [1].
If num_digits is greater than 0, the number is rounded to that many decimal places [1].
If num_digits is 0, the number is rounded to the nearest integer [1].
If num_digits is less than 0, the number is rounded to the left of the decimal point [1].

Syntax

The ROUND function takes two arguments, and both are required [1].

Argument	Required?	Meaning
`number`	Required	The number you want to round [1]
`num_digits`	Required	The number of digits to which you want to round the `number` argument [1]

The behavior of num_digits follows three rules [1]:

`num_digits` value	Effect	Example
Greater than 0	Rounds to that many decimal places	`=ROUND(23.7825,2)` returns 23.78
Exactly 0	Rounds to the nearest integer	`=ROUND(23.7825,0)` returns 24
Less than 0	Rounds to the left of the decimal point	`=ROUND(626.3,-3)` returns 1000

The general form is:

$$ \text{ROUND}(number,\ num\_digits) $$

How It Works

ROUND looks at the digit immediately after the position you are keeping. If the fractional part at that position is 0.5 or greater, the number is rounded up. If it is less than 0.5, the number is rounded down [2].

That rule applies to whole numbers too. When you round a whole number, Excel substitutes multiples of 5 for 0.5, so the rounding decision is made on the digit in the target position [2].

Negative numbers follow the same logic after a conversion step. Excel first converts the number to its absolute value, performs the rounding, then reapplies the negative sign [2]. For example, rounding -889 down to two significant digits gives -880: the value becomes 889, rounds to 880, and the sign is restored [2].

One practical consequence is that ROUND changes the stored value, not just the display. If you round 2.71828 to two decimal places, the cell holds 2.72, and later calculations use 2.72. That is different from applying a number format, which changes only how the value looks while the full precision stays in the cell.

If you need directional rounding instead of nearest-value rounding, Excel provides separate functions. ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero [1]. To round to a specific multiple, such as the nearest 0.5, use MROUND [1].

Worked Example

This example uses six lab measurements recorded to five decimal places. Each one is rounded to two decimal places and to the nearest whole number.

	A	B	C	D
1	Measurement	Value	ROUND to 2 dp	ROUND to 0 dp
2	Trial 1	3.14159	`=ROUND(B2,2)` -> displays 3.14	`=ROUND(B2,0)` -> displays 3
3	Trial 2	2.71828	`=ROUND(B3,2)` -> displays 2.72	`=ROUND(B3,0)` -> displays 3
4	Trial 3	1.61803	`=ROUND(B4,2)` -> displays 1.62	`=ROUND(B4,0)` -> displays 2
5	Trial 4	0.57721	`=ROUND(B5,2)` -> displays 0.58	`=ROUND(B5,0)` -> displays 1
6	Trial 5	2.30258	`=ROUND(B6,2)` -> displays 2.3	`=ROUND(B6,0)` -> displays 2
7	Trial 6	1.41421	`=ROUND(B7,2)` -> displays 1.41	`=ROUND(B7,0)` -> displays 1

The figure below shows the same layout: six measurements with columns for rounding to 2 decimal places and to 0 decimal places.

The key steps are:

C2 rounds the value in B2 to 2 decimal places.
D2 rounds the value in B2 to 0 decimal places, the nearest whole number.
C3 rounds the value in B3 to 2 decimal places.
D3 rounds the value in B3 to 0 decimal places.

Two rows are worth a closer look. Trial 4 has a value of 0.57721. Rounding to two decimal places gives 0.58 because the third decimal digit is 7, which is 0.5 or greater [2]. Rounding to zero decimal places gives 1 because the first decimal digit is 5 [2]. Trial 5 shows a display detail: 2.30258 rounds to 2.3, and in General format Excel drops the trailing zero. Apply a number format with two decimal places if you want it to show 2.30.

More Examples

Rounding to the left of the decimal point uses negative num_digits values. These cases come from the documented behavior of the function [1].

Formula	Result	What it does
`=ROUND(21.5,-1)`	20	Rounds 21.5 to one decimal place to the left of the decimal point [1]
`=ROUND(626.3,-3)`	1000	Rounds 626.3 to the nearest multiple of 1000 [1]
`=ROUND(1.98,-1)`	0	Rounds 1.98 to the nearest multiple of 10 [1]
`=ROUND(-50.55,-2)`	-100	Rounds -50.55 to the nearest multiple of 100 [1]

You can also nest ROUND inside other formulas. A common pattern is rounding the output of a division or an average so the reported figure matches the precision you want to publish. If you are building a larger workbook, the Excel formulas cheat sheet shows how ROUND fits alongside other core functions.

Rounding is often the last step in a calculation chain. If you compute a sum first and round second, the result can differ from rounding each input and then summing. Decide which order you need before you write the formula. The Excel SUM function guide covers aggregation in more detail.

Errors and How to Fix Them

#VALUE! error. This appears when one of the arguments is text that Excel cannot interpret as a number. Check that the number argument points to a numeric cell or a numeric literal. If the value came from another system, it may be stored as text, and you will need to convert it first.

#NAME? error. This usually means the function name is misspelled or the formula is missing an opening parenthesis. Confirm the formula reads =ROUND( with both arguments separated by a comma.

Unexpected rounding direction. If a value rounds the opposite way from what you expect, check the digit in the position after the one you are keeping. Values at 0.5 or above round up, and values below 0.5 round down [2]. If you need a fixed direction, switch to ROUNDUP or ROUNDDOWN [1].

Result looks unchanged. If the cell still shows the full-precision value, the formula may be referencing the wrong cell, or the cell may be formatted as text. Verify the reference and the cell format.

Common Mistakes

Confusing ROUND with number formatting. A number format changes only the display, while ROUND changes the stored value. If downstream formulas must use the rounded figure, use ROUND.
Forgetting that num_digits can be negative. Many users assume the second argument must be zero or positive. Negative values round to the left of the decimal point, which is useful for rounding to hundreds or thousands [1].
Using ROUND when you need a fixed direction. ROUND goes to the nearest value. If a rule requires always rounding up or always rounding down, use ROUNDUP or ROUNDDOWN instead [1].
Rounding too early in a calculation chain. Rounding intermediate results and then summing can produce a total that differs from rounding the final figure. Pick one order and apply it consistently.
Assuming ROUND handles significant digits directly. ROUND works on decimal positions, not significant digits. Rounding to significant digits requires a different setup, often combining ROUND with a logarithm or using ROUNDDOWN with a negative parameter [2].
Ignoring the effect on negative numbers. Excel converts a negative number to its absolute value, rounds, then reapplies the sign [2]. Test your negative cases so the output matches your expectations.

Limitations

ROUND controls decimal position, not significant digits. If your reporting standard is stated in significant figures, ROUND alone will not get you there, and you need a formula that accounts for the magnitude of the number [2]. It also cannot round to an arbitrary multiple such as the nearest 0.25 or the nearest 5. For those cases, MROUND is the right tool [1].

Rounding also introduces a difference between the rounded value and the original. In financial or scientific work, that difference can accumulate across many rows. Rounding each row and then totaling can give a different answer than totaling and then rounding, so the choice of where to round is a methodological decision, not a formatting one.

Frequently Asked Questions

How do you round numbers in Excel to two decimal places?

Use =ROUND(A1,2), replacing A1 with the cell that holds your value. The second argument, 2, tells Excel to keep two decimal places [1]. The cell then stores the rounded value, so any formula that references it uses the rounded figure.

What happens if num_digits is 0?

The number is rounded to the nearest integer [1]. For example, =ROUND(2.71828,0) returns 3 because the first decimal digit is 7, which is 0.5 or greater [2]. The result has no decimal places.

Can I round to the nearest hundred or thousand?

Yes. Use a negative num_digits value. =ROUND(626.3,-3) returns 1000, which is the nearest multiple of 1000 [1]. Each step further left adds another negative digit, so -2 rounds to the nearest hundred and -3 rounds to the nearest thousand.

What is the difference between ROUND and ROUNDUP?

ROUND goes to the nearest value, so it can round up or down depending on the digit that follows. ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero [1]. Choose based on whether your rule allows the direction to vary.

How can I round numbers in Excel without changing the underlying value?

Apply a number format to the cell instead of using ROUND. The format changes only what you see, and the full-precision value stays in the cell for calculations. If you need the stored value to change, use ROUND. If you only need the display to change, use formatting.