How To Divide In Excel | 3 Simple Ways

6.4 min read|Last Updated: February 1st, 2021|Categories: excel|
table of content

Unlike the SUM function that can automatically add cells’ values in Excel, there is no predefined division function in Excel. However, there are also several ways to do this math operation in this program. To read more about how to divide in Excel, follow this post to learn basic to advanced division methods in Excel.

How to divide in Excel 

Divide in Excel by using the divide symbol 

The simplest way to divide in Excel is by using the divide symbol (/). You can divide numbers into one cell or divide the amounts of multiple cells. We are going to explain each of them as follow:

First, to divide two amounts in one cell:

  • Select the cell that you want to apply the divide operation to.
  • Every formula in Excel should start with “=” so, write this symbol first.
  • Write the first number, and without any space, write / and then the second number. 
  • Press Enter to see the result.
Dividing two numbers in one cell in Excel.
Figure 1- Dividing two numbers in one cell in Excel

Remember, writing formulas with this method is not always useful. It is more practical to divide the amounts of two different cells. Consequently, if you change the value of each cell, the result will change. 

First, write the number in different cells. 

Dividing values of two cells in Excel.
Figure 2- Dividing values of two cells in Excel
  • Select the third cell where you want to display the result. It can be any cell on the sheet. (in our example we chose B5)
  • Start the formula by writing an equal sign “=”.
  • Select the first cell by clicking on it. (in our example it is B3)
  • Write “/” and select the second cell. (in our example is B4)
Write the division formula in the third cell where you want to see the result.
Figure 3- Write the division formula in the third cell where you want to see the result
  • Press Enter to see the result.