Need to divide one fraction by another in Excel? You can enter the entire problem directly into a formula or place each fraction in a separate cell and divide those cells.

In this tutorial, you’ll learn two easy ways to divide fractions in Microsoft Excel using the example 7/8 ÷ 5/4. You’ll also learn how fraction formatting affects the way Excel displays the answer and why parentheses are useful when entering the full calculation in one cell.

What You’ll Learn

  • How to divide fractions directly in an Excel formula
  • How to divide fractions stored in separate cells
  • How to format cells to display answers as fractions
  • Why Excel may initially display the answer as a decimal
  • How parentheses keep each fraction grouped correctly
  • The difference between a cell’s value and its number format

Common Uses

  • Checking fraction homework
  • Solving measurement problems
  • Working with recipes or serving sizes
  • Calculating material quantities
  • Dividing fractional dimensions
  • Using Excel as a basic calculator
  • Learning how Excel handles fractions

Requirements & Compatibility

This tutorial was originally recorded in 2019, and both methods remain accurate in Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016. Microsoft continues to support entering and calculating fractions, applying Fraction number formats, and using parentheses to control how formulas are evaluated.

The same basic calculations also work in Excel for the web, although the location of some formatting controls may differ slightly.

Practice & Resources

No practice files are required for this tutorial.

You can follow along in a blank Excel worksheet using the example 7/8 divided by 5/4, or replace those fractions with your own problem.

Video Tutorial

Breaking Down the Concepts

This tutorial demonstrates two ways to enter the same math problem. Both produce the same underlying result, but the setup and display are slightly different.

Method 1: Enter the Entire Problem in One Cell

=(7/8)/(5/4)

This method uses Excel like a calculator. The formula begins with an equals sign, which tells Excel to calculate what follows.

The forward slash / is Excel’s division symbol. It appears three times in this formula:

  • 7/8 creates the first fraction.
  • 5/4 creates the second fraction.
  • The slash between the two sets of parentheses divides the first fraction by the second.

Why are parentheses used?

The parentheses keep each fraction grouped as a single value:

(7/8) divided by (5/4)

They make the intended calculation clear and ensure Excel evaluates each fraction as a unit before dividing them. Parentheses are commonly used in Excel to control the order in which parts of a formula are calculated.

Why does Excel show 0.7?

If the result cell uses the default General number format, Excel displays the answer as a decimal:

0.7

That is the same value as:

7/10

Changing the cell to a Fraction format changes how the result appears, not its underlying value.

Method 2: Divide Fractions Stored in Cells

In the second method, each fraction is placed in its own cell:

B5C5D5
7/85/4=B5/C5

The formula is: =B5/C5

Excel divides the value stored in B5 by the value stored in C5.

Why this method is useful:

  • The original fractions remain visible.
  • You can change either fraction without rewriting the formula.
  • It is easier to build the calculation into a larger worksheet.
  • The formula clearly shows which cells are being divided.

Fraction Number Formatting

Before typing fractions directly into cells, format those cells as Fraction. Otherwise, Excel may interpret an entry such as 7/8 as a date, depending on your settings.

To apply the format:

  1. Select the cells.
  2. Open Format Cells.
  3. Select Fraction.
  4. Choose the desired fraction type.

Microsoft notes that Fraction formatting allows numbers to be entered and displayed as fractions while remaining available for calculations.

Why choose “Up to three digits”?

Excel offers formats that allow one-, two-, or three-digit denominators. A more detailed format can display a closer fractional representation of a decimal result.

For this example, 0.7 is exactly 7/10, so you need a format capable of displaying a two-digit denominator. Selecting Up to three digits easily accommodates that result.

This setting affects only the displayed fraction. Excel still stores and calculates the same numeric value underneath.

Step-by-Step Instructions

Method 1: Enter the Problem Directly

  1. Click an empty cell.
  2. Enter: =(7/8)/(5/4)
  3. Press Enter.
  4. Excel may initially display the answer as: 0.7
  5. To display it as 7/10, change the cell’s number format to Fraction.

Method 2: Divide Fractions in Separate Cells

  1. Select the cells you’ll use for the fractions and answer.
  2. Right-click and choose Format Cells.
  3. On the Number tab, select Fraction.
  4. Choose Up to three digits and click OK.
  5. Enter 7/8 in the first cell.
  6. Enter 5/4 in the second cell.
  7. In the answer cell, enter: =B5/C5
  8. Press Enter.

Excel displays the result as: 7/10

Additional Tips

  • Every Excel formula must begin with an equals sign (=).
  • Use a forward slash (/) for division.
  • Format cells as fractions before typing values such as 7/8 so Excel is less likely to interpret them as dates.
  • If Excel shows a decimal answer, the calculation is not necessarily wrong—the cell may simply be using the General number format.
  • Parentheses are especially helpful when entering multiple fractions directly into one formula.
  • Using separate cells is usually better when you want to reuse the worksheet with different numbers.

Related

How to Remove Extra Spaces in Excel

Learn how to remove extra spaces from text in Microsoft Excel using the TRIM function. This beginner-friendly tutorial explains what TRIM removes, when to use it, and why it’s one of the most useful functions for cleaning imported or inconsistent data.

How to Hide Zero Values (0s) in Excel

Learn two easy ways to hide zero values in Microsoft Excel without changing your formulas. This step-by-step tutorial demonstrates both the built-in worksheet option and a Conditional Formatting method to create cleaner spreadsheets, reports, and templates. Includes updated instructions and screenshots for current versions of Excel.

How to Create an Order Form with Drop-Down Menus in Microsoft Excel

Learn how to create a professional order form in Microsoft Excel using drop-down menus, Data Validation, and named ranges. This step-by-step tutorial also covers formatting dates, ZIP codes, and credit card fields to build cleaner, more accurate spreadsheets for real-world business use.

Stay Updated

There are two easy ways to get notified when new tutorials are published:

Subscribe on YouTube for new video tutorials: @SimpleSoftwareTutorials

or enter your email below to receive new blog posts directly in your inbox: