Divide by a fraction
Divide 1/2 by 1/4, each typed as a top and bottom number, to get 2.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | (A8*D8) | Multiplies the first top number by the second bottom number. | 4 |
| 2 | / | Divides the first result by the second. | 4 divided by … |
| 3 | (B8*C8) | Multiplies the first bottom number by the second top number. | 2, so 2 |
Dividing by a fraction is the same as flipping it and multiplying. The result is a number.
=(A8*D8)/(B8*C8)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. On the Template tab, paste the first fraction's top and bottom numbers into columns A and B. Put the one to divide by into C and D. The results fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Some results, like 1/2 divided by 3/4, are long decimals. Round them before sending if the file needs a set number of places.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Apply an FTE fraction to weekly hours
0.5 FTE of 40 hours → 20 hours
Get the template →
Turn fraction fields into a number
3 and 4 → 0.75; 3 and 0 → Review zero denominator
Get the template →
Get the fraction part, keeping its sign
-1.5 → -0.5
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →