How to Round Numbers in Excel (ROUND, ROUNDUP, ROUNDDOWN)

The Excel ROUND function rounds a number to the decimal places you choose, and its partners ROUNDUP and ROUNDDOWN force the direction. All three take the same two arguments: the number and how many digits to keep. This guide shows when to use each one, how negative digits work, and why rounding is not the same as hiding decimals with formatting.

How does the Excel ROUND function work?#

ROUND rounds a number to a set number of digits. If the next digit is 5 or more, it rounds up; otherwise it rounds down.

=ROUND(number, num_digits)

• number is the value, cell or formula to round.
• num_digits is how many decimal places to keep. Use 0 for a whole number.

So =ROUND(3.14159,2) returns 3.14, and =ROUND(2.5,0) returns 3.

ROUNDUP and ROUNDDOWN have exactly the same arguments:

Round to 2 decimal places#

Most prices and money amounts need two decimals. Here are unit costs with too many:

Type =ROUND(B2,2) in C2, then fill it down to C5 with Ctrl+D (Mac: ⌘D).

Look at the Charger. 18.995 rounds to 19.00, and Excel drops the trailing zeros unless the cell has a number format, so it shows 19. Format the column as currency or with two decimals if you want 19.00 on screen. The ROUND function reference has more examples.

When to use ROUNDUP and ROUNDDOWN#

Use ROUNDUP when you can't have a part of something, and ROUNDDOWN when only whole units count. Take an order of 130 units shipped in boxes of 24:

You can't ship 5.4 boxes, so you need 6. ROUND would give 5 here and leave units behind. In a real sheet, point to cells instead of typing the numbers, like =ROUNDUP(G1/G2,0).

ROUNDUP also works for prices. A shop that sets whole-dollar shelf prices and never sells below cost would use =ROUNDUP(B2,0). The Mouse at 7.0011 becomes 8, not 7, because ROUNDUP rounds up even when the extra is tiny.

ROUNDDOWN is the right choice when only completed units count. Years of service are a good example: someone who has worked 4.8 years has completed 4 full years, not 5. With a start date in B2, =ROUNDDOWN(YEARFRAC(B2,TODAY()),0) returns the full years. The method is explained in how to calculate age or years of service.

Round to tens, hundreds or thousands#

A negative num_digits rounds to the left of the decimal point. This is useful for summaries and forecasts.

Round to the nearest 5, 0.05 or 0.5#

ROUND only works in powers of ten, but a little arithmetic covers other steps. Divide by the step, round to a whole number, then multiply back:

This is handy for price lists, time sheets in half hours, or cash amounts in places without one-cent coins. Swap ROUND for ROUNDUP if the result must never be lower than the original value.

Rounding vs formatting: why your total looks wrong#

Formatting a cell to show fewer decimals only hides them. Excel still calculates with the full value. ROUND really changes the value.

Here is a classic example. Put =1/3 in three cells and format them to two decimals. Each one shows 0.33, but the total underneath shows 1.00, not 0.99. Excel is adding the hidden 0.33333… values. A reader adding the visible numbers gets 0.99 and thinks your sheet is wrong.

If the shown numbers must add up, round each value first: three cells of =ROUND(1/3,2) add up to exactly 0.99. Which approach is right depends on the report, but you should choose on purpose. This is one of the causes covered in why your Excel total is wrong. For a full side-by-side comparison, read ROUND vs ROUNDUP vs ROUNDDOWN (vs formatting).

Rounding the result of another formula#

You can put any formula inside ROUND. Wrap it around the calculation, not the other way round:

=ROUND(AVERAGE(B2:B6),0)
=ROUND((C2-B2)/B2,3)

The first gives a whole-number average. The second rounds a percent change to 3 decimals, so 0.072258 becomes 0.072, which displays as 7.2%. Percent change itself is explained in the percent change formula in Excel.

Count the parentheses. Each function needs its own closing bracket, so =ROUND(AVERAGE(B2:B6),0) has two.

When you copy a rounded formula that refers to a fixed cell, such as a tax rate, lock that cell with $. Absolute references and the $ sign shows how.

Negative numbers and other edge cases#

ROUND treats negative numbers by their size, so =ROUND(-2.5,0) returns -3. ROUNDUP and ROUNDDOWN go away from and towards zero, not up and down the number line:

For refunds, losses or negative variances, check that this matches what you need. Finance roles test this kind of detail often; see Excel skills for finance and accounting jobs.

Practise it#

Practise ROUND, ROUNDUP and ROUNDDOWN in a live spreadsheet: you'll round unit costs, work out boxes needed and full boxes, and set whole-dollar shelf prices. Then try the table-planning exercise on this page.