# 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.

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.

• 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)
• Press Enter to see the result.