Subtract fractions from separate fields
Take 1/2 from 3/4, each typed as a top and bottom number, to get 0.25.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8/B8 | Divides the first top number by its bottom number. | 0.75 |
| 2 | - | Takes the second fraction away from the first. | 0.75 - … |
| 3 | C8/D8 | Divides the second top number by its bottom number. | 0.5, so 0.25 |
Excel divides before it subtracts, so each fraction is worked out first.
=A8/B8-C8/D8How 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 two top and bottom numbers into columns A to D of the Template tab. The differences fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Make sure both fractions measure the same thing, like inches. A few results can be off by a tiny amount in far decimal places.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Multiply two fractions
1/2 times 3/4 → 0.375
Get the template →
Divide by a fraction
1/2 divided by 1/4 → 2
Get the template →
Apply an FTE fraction to weekly hours
0.5 FTE of 40 hours → 20 hours
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →