Rounding with ROUND

1 / 4

Splitting a bill gives long decimals. A2 divided by B2 is 42.596667... Nobody can pay that!

keyboard Typing formulas is easiest on a computer with a keyboard.

A1
ABCD
1BillPeopleEach pays
2127.793
3113.847
4175.584
5125.86
6
7
8
9
10
11
12
127.79
3 people
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
Study notes

How ROUND works

  • What does ROUND do?

    ROUND rounds a number to the number of decimal places you choose:

    =ROUND(number, num_digits)

  • How many decimal places?

    • =ROUND(29.1333, 2) gives 29.13 (2 decimal places: pennies).
    • =ROUND(29.1333, 0) gives 29 (a whole number).

  • Can you round a calculation?

    Yes: =ROUND(A2/B2, 2) works out A2/B2 first, then rounds the answer. Halves round up: 2.345 becomes 2.35.

Know someone fighting with a spreadsheet? Send them this page.