Round rates down to percent decimals
Turn 12.3456% into 12.34% so a rate is never overstated. Negative rates move lower.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The rate, such as 12.3456%. | 12.3456% |
| 2 | 10^(-B8-2) | The step size: 0.01% for 2 percent decimals. | 0.01% |
| 3 | FLOOR.MATH( … ) | Rounds down to that step, so negatives move lower. | 12.3400% |
The -2 is there because a rate of 1 is 100%. This changes the stored rate, not only how it looks. The rates are made-up.
=FLOOR.MATH(A8,10^(-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 how many 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 rule says to round rates down. Keep the original rates too.
Microsoft's help: FLOOR.MATH function
OTHER ROUTES YOU MIGHT LIKE

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 →
Turn 1 in 20 into a 5% rate
1 in 20 → 5.0%
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →