Round prices to the nearest cent with ROUND
BeginnerCalculated prices often produce messy decimals, especially when totals come from imported data or formulas. Before you send an invoice or share a report, you usually want every currency value to show a clean amount to the nearest cent.
ROUND returns a number with the number of decimal places you choose.
How ROUND works:
=ROUND(number, num_digits)
- number: the value you want to round
- num_digits: how many decimal places to keep
For currency, 2 means two decimal places.
What you need to do:
- Review the invoice table in rows 2:11. Column D already shows the raw totals.
- Click cell E2.
- Use ROUND to round the raw total in D2 to two decimal places.
- Press Enter.
- Copy the formula from E2 down through E11.
Example syntax:
=ROUND(B2, 2)
When you're done, column E should show clean invoice totals rounded to the nearest cent.
Need some help?
Hint 1
The value you need to clean up is already calculated for you in column D, so ROUND should point to the raw total, not back to the quantity or unit price.
Hint 2
Start in E2 by rounding the value in D2 to 2 decimal places, then fill that pattern down through E11.
Round prices to the nearest cent with ROUND
BeginnerCalculated prices often produce messy decimals, especially when totals come from imported data or formulas. Before you send an invoice or share a report, you usually want every currency value to show a clean amount to the nearest cent.
ROUND returns a number with the number of decimal places you choose.
How ROUND works:
=ROUND(number, num_digits)
- number: the value you want to round
- num_digits: how many decimal places to keep
For currency, 2 means two decimal places.
What you need to do:
- Review the invoice table in rows 2:11. Column D already shows the raw totals.
- Click cell E2.
- Use ROUND to round the raw total in D2 to two decimal places.
- Press Enter.
- Copy the formula from E2 down through E11.
Example syntax:
=ROUND(B2, 2)
When you're done, column E should show clean invoice totals rounded to the nearest cent.
Need some help?
Hint 1
The value you need to clean up is already calculated for you in column D, so ROUND should point to the raw total, not back to the quantity or unit price.
Hint 2
Start in E2 by rounding the value in D2 to 2 decimal places, then fill that pattern down through E11.