Excel guide · 3 min read

ROUND vs ROUNDUP vs ROUNDDOWN in Excel

Q: How do I round to the nearest whole number in Excel?

Use =ROUND(B7,0). 3.4 hours becomes 3 and 3.5 becomes 4. For always up use ROUNDUP(B7,0), for always down ROUNDDOWN(B7,0).

Quick answerROUND rounds to the nearest value (5 and up goes up), ROUNDUP always rounds away from zero, and ROUNDDOWN always rounds toward zero, which just cuts off the extra digits. All three take the same arguments: the number and how many decimal places to keep, for example =ROUND(B2,2). Use ROUND for money totals, ROUNDUP when you must not come up short (boxes, billable units), and ROUNDDOWN for complete units only.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

	A	B
1	Item	Value
2	Invoice total	1847.3249
3	Refund	-64.875
4	Parcel weight (kg)	2.3
5	Units to pack	130
6	Units per box	24
7	Hours worked	3.4

Side by side on the same number

The invoice total in B2 is 1,847.3249 after a percentage discount. Rounded to cents, the three functions give: =ROUND(B2,2) is 1,847.32, =ROUNDUP(B2,2) is 1,847.33, and =ROUNDDOWN(B2,2) is 1,847.32.

ROUND looks at the next digit (4) and rounds down. ROUNDUP ignores that and goes up. ROUNDDOWN drops everything after the second decimal. ROUND always matches one of the other two; it just picks the nearer.

=ROUNDUP(B2,2)

Result: 1847.33

1,847.33: ROUNDUP goes up even though the next digit is only 4.

ROUNDUP: when coming up short is a problem

You have 130 units to pack and a box holds 24. 130/24 is 5.42 boxes, and you cannot order 0.42 of a box. ROUNDUP with 0 decimal places gives whole boxes.

The same logic applies to courier charges per started kilogram (=ROUNDUP(B4,0) turns 2.3 kg into 3), billing per started hour, and how many buses or tables you need.

=ROUNDUP(B5/B6,0)

Result: 6

6 boxes, so every unit fits.

ROUNDDOWN: complete units only

Flip the question: how many boxes can you fill completely? Now 5.42 must become 5. ROUNDDOWN is right for full boxes, whole years of service, and "how many can I afford" questions.

For whole numbers, INT does almost the same, but see the negative numbers section below: INT and ROUNDDOWN disagree on negatives.

=ROUNDDOWN(B5/B6,0)

Result: 5

5 full boxes, with 10 units left over.

Negative digits: round to tens, hundreds, thousands

A negative second argument rounds to the left of the decimal point: -1 is tens, -2 is hundreds, -3 is thousands. =ROUND(B2,-2) gives 1,800, and =ROUNDDOWN(B2,-2) also gives 1,800. ROUNDUP goes to the next hundred.

This is handy for budgets and headline figures. To round to a step that is not a power of 10, like the nearest 5 or 25, use MROUND, CEILING.MATH or FLOOR.MATH instead.

=ROUNDUP(B2,-2)

Result: 1900

1,900: up to the next hundred.

Negative numbers: up means away from zero

ROUNDUP and ROUNDDOWN work on the size of the number, not its direction on the number line. A refund of -64.875 rounded up to cents becomes -64.88, which is a bigger refund. ROUNDDOWN(B3,2) gives -64.87.

INT is different: it always goes down the number line, so =INT(-2.5) is -3 while =ROUNDDOWN(-2.5,0) is -2. If your data can be negative, pick ROUNDDOWN when you mean "cut off the decimals".

=ROUNDUP(B3,2)

Result: -64.88

-64.88: away from zero.

Common mistakes

Formatting instead of rounding

Decrease Decimal on the Home tab only changes what you see. The full value is still used in sums, so totals can look one cent off. Round in the formula if the stored value must match the display.

Rounding each line, then the total, and expecting a match

The sum of rounded lines can differ from the rounded sum by a cent or two. Decide which one is official (invoices usually round each line) and do it consistently.

Using INT on negative numbers

INT(-3.2) is -4, not -3. Use ROUNDDOWN(x,0) or TRUNC(x) to drop the decimals toward zero.

Forgetting the second argument

ROUND needs num_digits. Use 0 for whole numbers; =ROUND(B2) gives an error that you have entered too few arguments.

FAQ

How do I round to the nearest whole number in Excel?

Use =ROUND(B7,0). 3.4 hours becomes 3 and 3.5 becomes 4. For always up use ROUNDUP(B7,0), for always down ROUNDDOWN(B7,0).

Does Excel round 0.5 up or to even?

ROUND rounds halves away from zero, so 2.5 becomes 3 and -2.5 becomes -3. It does not use banker's rounding (round half to even).

What is the difference between ROUNDDOWN and TRUNC?

For numbers they give the same result: both cut digits off toward zero. TRUNC lets you skip the second argument (it defaults to 0), while ROUNDDOWN requires it.

How do I round to the nearest 5 or 0.25?

Use MROUND(number, 5) or MROUND(number, 0.25). CEILING.MATH always goes up to the step and FLOOR.MATH always goes down.

Functions used

Related guides

Updated November 2, 2026