Multiply two fractions
Multiply 1/2 by 3/4, each typed as a top and bottom number, to get 0.375.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | (A8*C8) | Multiplies the two top numbers. | 3 |
| 2 | / | Divides the first result by the second. | 3 divided by … |
| 3 | (B8*D8) | Multiplies the two bottom numbers. | 8, so 0.375 |
The result is a number. To show it as a fraction, use Excel's Fraction number format.
=(A8*C8)/(B8*D8)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 second's into C and D. The products 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/3, 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

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 →
Turn fraction fields into a number
3 and 4 → 0.75; 3 and 0 → Review zero denominator
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →