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

In Excel: 1/2 times 3/4 becomes 0.375.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult 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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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.