Write an exact mixed-number label
Turn a top number 7 and bottom number 4 into 1 3/4, exactly.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | QUOTIENT(A8,B8) | How many whole times 4 fits in 7. LET calls it whole. | 1 |
| 2 | MOD(A8,B8) | What is left over. LET calls it remn. | 3 |
| 3 | GCD(remn,B8) | The largest number that divides both. LET calls it g. | 1 |
| 4 | IF(remn=0, … ) | Writes the whole number, then the reduced leftover. | "1 3/4" |
| 5 | LET( … ) | Names each step so the formula reads in order. | "1 3/4" |
Nothing is left over in 8/4, so it shows only 2. Under one, like 3/4, there is no 0 in front.
=LET(whole,QUOTIENT(A8,B8),remn,MOD(A8,B8),g,GCD(remn,B8),IF(remn=0,whole&"",IF(whole=0,"",whole&" ")&remn/g&"/"&B8/g))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 mixed numbers 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 of zero or more, with a bottom number above zero. Decimals and minus signs aren't handled here.
Microsoft's help: GCD function
OTHER ROUTES YOU MIGHT LIKE

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 →
Write a value in eighths like 4/8
0.5 → 4/8
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →