Main content
What is it?
Rounding does not replace conversion. It only changes how many digits you reveal after the value is already defined. If you skip that order, you can accidentally teach readers that the rounded label is the true ratio.
If mistakes persist after you change digits, walk through the mistakes checklist on this site before you blame formatting alone. Often the issue is direction or base confusion rather than digit count.
That checklist lives in common conversion mistakes and pairs well with this article when you review student work or client tables.
Formula
Use full precision internally when a decision depends on small differences. Apply ROUND or format strings at the boundary where humans read the output, and keep a copy of the unrounded column for reconciliation.
If you publish both internal and external versions, label files clearly so nobody merges the wrong layer during a late-night export.
Classroom practice sets benefit from study notes on this site when students move from paper to Sheets, because the rubric language often mentions how many decimal places to show.
Step-by-step guide
- Compute using unrounded values in the model layer.
- Copy final outputs to a presentation layer.
- Apply rounding rules that match your rubric or style guide.
- Label charts when truncated digits could change interpretation.
- Archive the rounding rule in writing next to the table.
Example
A rate of 0.083333... may display as 8.3% or 8.33% depending on policy. The underlying conversion rule is the same either way, which is why two honest teams can still argue if they compare different display layers.
For tiny headline moves, compare against basis point language before you argue about tenths of a percent, because the headline may be using a finer unit than your chart axis.
