ROUND: choose precision deliberately
ROUND affects the number you keep for a calculation, not just the digits a cell displays. That distinction can matter when totals are built from many small amounts.
The one-cent difference is a policy choice about rounding order, not necessarily a formula bug. Displaying two decimal places does not replace the underlying value used in later calculations. ROUND changes the calculated value; formatting changes how it appears.
| Formula | Expected result / interpretation |
|---|---|
| =ROUND(A2,2) | 1.23 |
| =ROUND(A2,2)+ROUND(A3,2) | 2.46 — round each line, then sum |
| =ROUND(SUM(A2:A3),2) | 2.47 — sum unrounded lines, then round |
| =ROUND(-2.5,0) | -3 |
| Cell | Unrounded value |
|---|---|
| A2 | 1.234 |
| A3 | 1.234 |
Enter the unrounded line values below in A2:A3. Both represent sample calculations that produced three decimal places.
Choose when rounding belongs in an invoice
Formula syntax
=ROUND(number, num_digits)
What goes into it
number
Value to round.
num_digits
Digits after the decimal when positive; places to the left when negative.
A quick example first
=ROUND(12.3456,2)
Returns 12.35.
=ROUND(1267,-2)
Rounds to the nearest hundred.
Before you copy this into a real sheet
Agree on a rounding rule before reconciling invoices. Preserve the unrounded amount if the calculation must be audited. ROUND handles numeric precision, not exchange-rate selection, tax rules or currency-specific accounting requirements. For fixed increments, choose an appropriate increment formula rather than assuming two decimal places is always correct. Avoid testing floating-point decimal calculations for exact equality when a justified tolerance or explicit rounding rule is more appropriate.
Useful habits
- Round at the presentation/business-rule point, not repeatedly through intermediate calculations unless required.
- Negative num_digits rounds to tens, hundreds and beyond.
- Use ROUNDUP/ROUNDDOWN when direction must be controlled.
Where people get caught out
- Assuming cell display formatting changes the stored calculation value.
- Rounding intermediate financial values inconsistently with the required business rule.
Other functions worth a look
A detail worth remembering
Check whether your policy says to round each line item or only the final total. Those methods can produce different answers.
Reference and examples
The examples above use small, invented datasets and English-language formula names. Check your Excel version and argument separator against the official Excel function reference if a formula behaves differently on your computer.