Round a rate to chosen percent decimals
Turn the rate 12.3456% into 12.35%, rounded to 2 percent decimals.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The rate, like 12.3456%. | 12.34560% |
| 2 | B8 | How many decimals to keep after the %. | 2 |
| 3 | +2 | Adds 2, because a percent moves the point 2 places. | 4 |
| 4 | ROUND( … ) | Rounds the rate to that many places. | 12.3500% |
This changes the number itself. Half rounds up. Results always show 4 decimals, so 12.35% shows as 12.3500%.
=ROUND(A8,B8+2)How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own rates. On the Template tab, paste rates into column A. Put the percent decimals to keep, 0 to 4, into column B.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only when your source says to round the rate itself. To show fewer decimals and keep the rate, change the format.
Microsoft's help: ROUND function
OTHER ROUTES YOU MIGHT LIKE

Round rates down to percent decimals
12.3456% to 2 decimals → 12.34%
Get the template →
Round rates up to percent decimals
12.3456% to 2 decimals → 12.35%
Get the template →
Turn a ratio like 1:4 into a 20% share
1:4 ratio → 20% share, not 25%
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →