Round a rate to chosen percent decimals

Turn the rate 12.3456% into 12.35%, rounded to 2 percent decimals.

What you'll make

In Excel: 12.34560% at 2 percent decimals becomes 12.3500%.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The rate, like 12.3456%.12.34560%
2B8How many decimals to keep after the %.2
3+2Adds 2, because a percent moves the point 2 places.4
4ROUND( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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