Round amounts down to set decimals
Turn -12.345 into -12.35: negative amounts move further below zero, not toward it.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The amount to round. | -12.345 |
| 2 | 10^-B8 | The step size: 0.01 for 2 decimals. | 0.01 |
| 3 | FLOOR.MATH( … ) | Rounds down to that step, so negatives move lower. | -12.35 |
Positive amounts drop toward zero, negative ones away from it. The amounts are made-up.
=FLOOR.MATH(A8,10^-B8)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 amounts. On the Template tab, paste amounts into column A. Put the number of 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 down. For credits it gives a bigger negative amount.
Microsoft's help: FLOOR.MATH function
OTHER ROUTES YOU MIGHT LIKE

Calculate a line amount to the cent
12.345 × 3 → 37.04
Get the template →
Convert amounts with a currency rate
125.5 × 0.9215 to 2 decimals → 115.65
Get the template →
Keep amounts between set limits
640.25 with limits 25 to 500 → 500
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →