Ranges and functions · ROUND, and functions inside functionsWorks in: all current Excel versions, Google Sheets
ROUND changes the value
A format only changes how a number looks. ROUND changes the value itself, so every later calculation uses the rounded number. Money is usually rounded to 2 decimals (cents) at the point it's charged.
=ROUND(D2/C2,2) divides first, then rounds the result to 2 decimals. (ROUNDUP and ROUNDDOWN work the same way but always round up or down.)
Syntax
ROUND(number, digits)
- number
- the value or calculation to round, like
D2/C2. - digits
- how many decimals to keep: 2 for cents, 0 for whole numbers.
Common mistakes
- Leaving out the digits:
ROUND(D2/C2)isn't complete. - Rounding with a format and expecting the totals to add up in cents: they use the hidden decimals.
Tap Try it to round every category's spend ratio.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Type | Budget | Actual | Ratio |
| 2 | Rent | Fixed | $1,200.00 | $1,200.00 | |
| 3 | Groceries | Variable | $450.00 | $512.40 | |
| 4 | Utilities | Fixed | $160.00 | $148.75 | |
| 5 | Transport | Variable | $120.00 | $96.50 | |
| 6 | Phone & internet | Fixed | $65.00 | $65.00 | |
| 7 | Eating out | Variable | $150.00 | $203.10 | |
| 8 | Subscriptions | Fixed | $38.00 | $44.97 | |
| 9 | Gym | Fixed | $40.00 | $40.00 | |
| 10 | Gifts | Variable | $60.00 | $25.00 | |
| 11 | Savings | Fixed | $300.00 | $300.00 |
Tap Try it to type =ROUND(D2/C2,2) into E2.
Go deeper: Percentage change, percent of total and running totals