Rewrite a fraction at a new denominator

Turn 1/2 into 4/8, and flag 1/3, which has no exact form in eighths.

What you'll make

In Excel: 1/2 in eighths becomes 4/8.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1MOD(A8*C8,B8)=0Checks the new top number comes out whole.Yes
2A8*C8/B8&"/"&C8Works out the new top number and adds /8."4/8"
3"Review: not exact"What the cell says when it isn't exact.Not used for row 8
4IF( … )Uses part 2 when exact, otherwise part 3."4/8"

The result is text and is not reduced, so 4/8 stays 4/8. Nothing is rounded.

=IF(MOD(A8*C8,B8)=0,A8*C8/B8&"/"&C8,"Review: not exact")

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. On the Template tab, paste top numbers into column A and bottom numbers into column B. Put the new bottom numbers into column C. The fractions fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Rows that say Review can't be written exactly at that denominator. Choose another one or keep the original fraction.

Microsoft's help: MOD function