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.

ABCDE
1CategoryTypeBudgetActualRatio
2RentFixed$1,200.00$1,200.00
3GroceriesVariable$450.00$512.40
4UtilitiesFixed$160.00$148.75
5TransportVariable$120.00$96.50
6Phone & internetFixed$65.00$65.00
7Eating outVariable$150.00$203.10
8SubscriptionsFixed$38.00$44.97
9GymFixed$40.00$40.00
10GiftsVariable$60.00$25.00
11SavingsFixed$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