Percentages stored as decimals (0.1234 = 12.34%) need rounding at the decimal level. To show a whole-number percent, round to 2 decimals; for one decimal place, round to 3.
The example
0.12345 → 0.12 displays as 12%.
| A | B | |
|---|---|---|
| 1 | Rate | Whole % |
| 2 | 0.12345 | 0.12 → 12% |
The formula
The formula:
How it works
How it works:
- Percentages are stored as decimals — 12.34% is really 0.1234.
- To round to a whole-number percent, round the decimal to 2 places:
ROUND(rate, 2). - For one decimal place in the percent (12.3%), round to 3 places.
- This rounds the actual value so it matches the displayed percent — formatting alone would leave hidden decimals.
Shares that must total 100%: rounding each percentage independently can make the parts sum to 99% or 101%. The largest-remainder method fixes this — round all down, then add the leftover percentage points to the entries with the biggest fractional remainders.
Try it: interactive demo
Rate (as a decimal).
Variations
One decimal place
12.3%:
Round to nearest 5%
Snap to 0.05:
From a ratio
Compute then round:
Pitfalls & errors
Off-by-one in digits. Whole-number percent = round to 2 decimals; the percent display adds two zeros.
Parts may miss 100%. Independent rounding can leave a 1% gap — use largest-remainder if it must sum.
Round the value, not the view. Percent formatting hides decimals but keeps them stored.
Practice workbook
Frequently asked questions
How do I round a percentage in Excel?
Why round to 2 decimals for a whole percent?
How do I make percentages add up to 100%?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class