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

In Excel: -12.345 to 2 decimals becomes -12.35.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The amount to round.-12.345
210^-B8The step size: 0.01 for 2 decimals.0.01
3FLOOR.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.

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