Get the fraction part, keeping its sign

Turn -1.5 into -0.5, so a minus number keeps its minus sign.

What you'll make

In Excel: -1.5 becomes -0.5.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The number, like -1.5.-1.5
2TRUNC(A8)The whole part, cut toward zero.-1

The minus sign between them takes part 2 away from part 1: -1.5 minus -1 is -0.5. A whole number gives 0.

=A8-TRUNC(A8)

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 numbers. Paste numbers into the green column of the Template tab. The fraction parts fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Some results are off by a tiny hidden amount, like 2.3 giving 0.3 that isn't exactly 0.3. Round before comparing.

Microsoft's help: TRUNC function