Confident Cells

ROUND, ROUNDUP and ROUNDDOWN

20 November 2026 · 2 min read

=ROUND(A2,2) rounds to 2 decimal places, the usual way: 2.345 becomes 2.35. ROUNDUP always goes up and ROUNDDOWN always goes down, whatever the next digit is. The second number says how many decimal places to keep.

The three, side by side

ABCD
1NumberROUND to 1 dpROUNDUP to 1 dpROUNDDOWN to 1 dp
22.7122.72.82.7
32.7892.82.82.7
42.752.82.82.7
ROUNDUP takes 2.712 up to 2.8, even though the next digit is only 1.

The second number can be:

When to round up

Whenever part of something isn't enough. 130 people on a trip, and each coach takes 52:

  1. 130 ÷ 52 = 2.5 coaches.
  2. Half a coach isn't possible, and 2 would leave people behind, so you need 3.
=ROUNDUP(B2/$F$1,0)

The same goes for boxes, packs, staff and minimum orders. ROUNDDOWN suits the opposite: how many whole packs can you make from what's in stock.

Rounding or formatting?

The "decrease decimal" button only changes how a number looks. 2.345 still shows as 2.35, but the cell still holds 2.345, and totals use the full value. That's why a column of rounded-looking figures can add up to a penny more or less than you expect. If the rounded figure is the real answer (an invoice, a grade), round it with a formula.

Common mistakes

Forgetting the second number

ROUND needs it: Excel won't accept =ROUND(A2). Use 0 for whole numbers.

Rounding too early

Rounding each step of a long calculation lets small errors build up. Round once, at the end, unless each line really is rounded (like VAT on an invoice line).

Rounding to steps like 0.5 or 5

For the nearest half day or nearest 5, use MROUND, CEILING or FLOOR: =CEILING(4.2,0.5) gives 4.5 (see holiday entitlement).

Try it now

Your turn

Each coach seats the number of people in G1. In C2, work out how many coaches each trip needs, so that nobody is left behind. Your formula will be copied down to C7.

ABCDEFG
1TripPeopleCoachesSeats per coach52
2Museum130
3Theatre52
4Zoo75
5Beach160
6Castle104
7Gallery30