Write an exact reduced fraction
Turn a top number 6 and bottom number 8 into 3/4, exactly.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8/GCD(ABS(A8),B8) | Divides the top number by the largest shared factor. | 3 |
| 2 | &"/"& | Puts a slash between the two numbers. | "3/" |
| 3 | B8/GCD(ABS(A8),B8) | Divides the bottom number by the same factor. | "3/4" |
GCD finds the largest whole number that divides both, here 2. Zero gives 0/1, and a whole number keeps /1.
=A8/GCD(ABS(A8),B8)&"/"&B8/GCD(ABS(A8),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 numbers. Paste the top numbers into column A and the bottom numbers into column B of the Template tab. The fractions fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use whole numbers only. A decimal like 0.75 isn't turned into a fraction here.
Microsoft's help: GCD function
OTHER ROUTES YOU MIGHT LIKE

Write an exact mixed-number label
7/4 → 1 3/4
Get the template →
Build a fractional house-number label
12 and 0.5 → 12 1/2
Get the template →
Write a count like 15 out of 20
15 and 20 → 15 out of 20
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →