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

In Excel: 1/2 divided by 1/4 becomes 2.

The formula

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

  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 one to divide by into C and D. The results 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/2 divided by 3/4, are long decimals. Round them before sending if the file needs a set number of places.